Re: Arrays and foreign keys

Well, the two types aren't the same (one is an integer the
other an integer array,) so I wouldn't expect it to work. Note:
This shows another thing it probably should check before allowing
the constraint to be created.

I don't know if these belong in TODO, but this might
be the appropriate entry.
* Make sure that types used in foreign key constraints
are comparable.

Stephan Szabo
sszabo(at)bigpanda(dot)com

On Tue, 8 Aug 2000, Kaare Rasmussen wrote:

> Seems that it's not possible to combine arrays and foreign keys ?
>
> CREATE TABLE table1 (
> fld1 integer NOT NULL,
> number integer,
> level integer,
> PRIMARY KEY (fld1)
> );
>
> CREATE TABLE table2 (
> pkey integer NOT NULL,
> arvar integer[],
> PRIMARY KEY (pkey),
> FOREIGN KEY (arvar) REFERENCES table1(fld1)
> );
>
>
> This works, but the following insert complains that
>
> ERROR: Unable to identify an operator '=' for types 'int4' and '_int4'
> You will have to retype this query using an explicit cast