Arrays and foreign keys

Kaare Rasmussen <kar@webline.dk>

From: Kaare Rasmussen <kar@webline.dk>
To: pgsql-hackers@postgresql.org
Date: 2000-08-08T20:03:11Z
Lists: pgsql-hackers
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

-- 
Kaare Rasmussen            --Linux, spil,--        Tlf:        3816 2582
Kaki Data                tshirts, merchandize      Fax:        3816 2582
Howitzvej 75               ben 14.00-18.00        Email: kar@webline.dk
2000 Frederiksberg        Lrdag 11.00-17.00       Web:      www.suse.dk