Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Peter Childs <Blue(dot)Dragon(at)blueyonder(dot)co(dot)uk>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)
Date: 2003-10-08 22:30:18
Message-ID: 200310082230.h98MUIf08911@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Jan Wieck wrote:
> > I think this is a larger argument than the one that was being discussed
> > above. Given a dump of objects I own, can I restore them without requiring
> > the fk check to be done if I alter table add constraint a foreign key? If
> > the answer to that is no, then the option can be put in as a superuser
> > only option and it's relatively easy. If the answer to that is yes, then
> > there are additional issues that need to be resolved.
>
> Well, with the CREATE CONSTRAINT TRIGGER you _can_, but we already have
> a consensus that we don't _want_ that. Probably we should declare it
> deprecated and remove it in 7.5. And the option currently under
> discussion is exactly what will cause ALTER TABLE to let you, but IMHO
> that _should_ be restricted.

Added to TODO:

* Remove CREATE CONSTRAINT TRIGGER

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2003-10-08 22:31:32 Re: Humor me: Postgresql vs. MySql (esp. licensing)
Previous Message Martin Marques 2003-10-08 22:29:01 Re: Cross database foreign key workaround?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-10-08 23:08:47 Re: [HACKERS] Cannot dump/restore text value \N
Previous Message Gaetano Mendola 2003-10-08 22:27:55 Autovacuum readme