Skip site navigation (1) Skip section navigation (2)

Re: Arrays and Indices / Foreign Keys

From: Alex <alex(at)meerkatsoft(dot)com>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Arrays and Indices / Foreign Keys
Date: 2003-08-29 01:36:56
Message-ID: 3F4EAE38.6090608@meerkatsoft.com (view raw or flat)
Thread:
Lists: pgsql-general
Joe, that is good news.
When will be 7.4 availbable?

Also,
what i actually wanted  is to ckeck that if  lets say ARRAY[1,2,3]
 is inserted but 1,2 or 3 (the the entire array) is not  present in the 
reference table.
Will that be available too ?

Alex


Joe Conway wrote:

> Alex wrote:
>
>> a) index array fields
>
>
> It is possible in 7.4 beta, but not before.
>
>> b) to create a foreign key constraint from the array
>
>
> Same answer. In 7.4:
>
> # CREATE TABLE t1 (id int[] PRIMARY KEY);
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
> "t1_pkey" for table "t1"
> CREATE TABLE
> # INSERT INTO t1 VALUES(ARRAY[1,2,3]);
> INSERT 2028925 1
> # CREATE TABLE t2 (id int, fk int[] REFERENCES t1(id));
> NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY 
> check(s)
> CREATE TABLE
> # INSERT INTO t2 VALUES(1, ARRAY[1,2,3]);
> INSERT 2028935 1
> # INSERT INTO t2 VALUES(2, ARRAY[3,4,5]);
> ERROR:  insert or update on "t2" violates foreign key constraint "$1"
> DETAIL:  Key (fk)=({3,4,5}) is not present in "t1".
>
> Joe
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>



In response to

Responses

pgsql-general by date

Next:From: Williams, Travis L, NEODate: 2003-08-29 01:46:34
Subject: Re: Join question
Previous:From: Williams, Travis L, NEODate: 2003-08-29 01:32:39
Subject: Re: Join question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group