From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.5-pre1 (2020-06-20) on
	ip-172-31-74-118.ec2.internal
X-Spam-Level: *
X-Spam-Status: No, score=1.8 required=3.0 tests=BAYES_50,FORGED_GMAIL_RCVD,
	FREEMAIL_FROM autolearn=no autolearn_force=no version=3.4.5-pre1
Path: eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: Gavin McCord <gavind.mccord@gmail.com>
Newsgroups: comp.lang.ada
Subject: Creating schema file for use with gnatcoll_db2ada involving array
Date: Mon, 21 Dec 2020 23:38:04 -0000 (UTC)
Organization: A noiseless patient Spider
Message-ID: <rrrbks$v4i$1@dont-email.me>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Injection-Date: Mon, 21 Dec 2020 23:38:04 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="6f27dada70bea89f56a6804bd3388402";
	logging-data="31890"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX18m1A44LmjqijD0sRp/U6HzxH4sgG78PIiMK+j/T0wodw=="
User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508
 git://git.gnome.org/pan2)
Cancel-Lock: sha1:cODEDb1i8lmT9u3YocVxpzF3xHg=
Xref: reader02.eternal-september.org comp.lang.ada:60918
List-Id: <comp.lang.ada>

I've created a database (for invoicing purposes) in
postgresql (running on Slackware 14.2), with a few tables
and all is working so far.

Now I want to start using Ada (currently on GNAT 2020) as
the interface and also have managed to do basic querying.

But I come unstuck having added another table which
includes an array (in this case one of bigint).

Part of the schema file all-schema.txt) looks like this:


| TABLE        | invoices      | invoice      |        ||
| inv_num      | AUTOINCREMENT | PK, NOT_NULL |        || 
| inv_date     | TIMESTAMP     |              |        ||
| cust_id      | VARCHAR(15)   | NOT_NULL     | 'SHOP' ||
| item_list    | BIGINT[]      |              |        ||
| tot_price    | BIGINT        | NOT_NULL     | 0      ||
| posted       | BOOLEAN       | NOT_NULL     | FALSE  ||

The "item_list" column is where it falls down. The command:

  gnatcoll_db2ada -dbmodel all-schema.txt

Gives me the following:

  Error: unknown field type "BIGINT[]"
  all-schema.txt:33 gnatcoll-sql-inspect.adb:1420
  gnatcoll-sql-inspect.adb:1420

Is what I'm trying to do even possible?

Thanks for any assistance.

Gavin