From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
---|---|
To: | Markus Bertheau <twanger(at)bluetwanger(dot)de> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Incomprehensible behaviour of a foreign key. |
Date: | 2003-07-20 13:47:30 |
Message-ID: | Pine.LNX.4.21.0307201439140.16690-100000@ponder.fairway2k.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 20 Jul 2003, Markus Bertheau wrote:
> Ð ÐÑк, 20.07.2003, в 15:15, Nigel J. Andrews пиÑеÑ:
> > As usual I forgot to include the version number. It's 7.3.3
>
> Table schemas will be helpful, too.
All tables are in the one and only schema listed in the users search path and
the three tables and the relevent columns used in the test script are:
create table groups (
id serial primary key
,name text
,principal_user_id int references anothertable(id)
,...
) without oids;
create table sections (
id serial primary key
,group_id int references groups(id)
,...
) without oids;
create table site_membership (
id serial unique
,group_id int references groups(id)
,site_id int references someothertable(id)
,primary key(site_id,group_id)
) without oids;
Hope that's enough to give you the idea of the linkages.
--
Nigel Andrews
From | Date | Subject | |
---|---|---|---|
Next Message | Nigel J. Andrews | 2003-07-20 13:52:44 | Re: Incomprehensible behaviour of a foreign key. |
Previous Message | Stephan Szabo | 2003-07-20 13:44:07 | Re: Incomprehensible behaviour of a foreign key. |