Re: foreign keys - Mailing list pgsql-general

From Stephan Szabo
Subject Re: foreign keys
Date
Msg-id Pine.BSF.4.10.10008071537040.52054-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: foreign keys  (<vectro@pipeline.com>)
List pgsql-general
On Sun, 6 Aug 2000 vectro@pipeline.com wrote:

> > Seriously, for foreign key constraints, you can remove them by removing
> > the rows in pg_trigger that are associated with them.  If they're unnamed,
> > you'll have to use the data in tgargs to determine which is the correct
> > one.
>
> Perhaps we should come up with a better naming convention than <unnamed>
> for unnamed constraints? Like is done with implied indices and sequences.

Definately.  It's on my hopefully to get done reasonably soon list since
Jan's really busy with TOAST.  I'm actually trying to get it done mostly
correctly to the SQL spec which is why I haven't hit it yet.  I want to
make sure that constraint names (or at least fk constraint names) never
conflict with any other constraint name in the database (schema
technically - but until we have schemas...).



pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: pg_dump help
Next
From: Philip Warner
Date:
Subject: Re: [HACKERS] Re: Trouble with float4 afterupgrading from 6.5.3 to 7.0.2