From: | "Dan Langille" <dan(at)langille(dot)org> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: 7.4 - TODO : alter table drop foreign key |
Date: | 2002-12-05 16:47:09 |
Message-ID: | 3DEF3CBD.8722.684C76B@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 5 Dec 2002 at 8:44, Stephan Szabo wrote:
> On Thu, 5 Dec 2002, Dan Langille wrote:
>
> > On 5 Dec 2002 at 8:20, Stephan Szabo wrote:
> >
> > >
> > > On Thu, 5 Dec 2002, Dan Langille wrote:
> > >
> > > > We support "alter table add foreign key". How about supporting
> > > > "alter table drop foreign key"?
> > > >
> > > > - he said as he went to drop a foreign key
> > >
> > > It seems to work for me on my 7.3b2 system with
> > > alter table <table> drop constraint <constraint name>;
> >
> > Premature send.. sorry
> >
> > How was that FK added? How did you determine the constraint name?
>
> alter table <table> add constraint <name> foreign key ...
>
> > How would you do that if the FK was added with the following syntax?
> >
> > alter table <table>
> > add foreign key (<column>)
> > references <othertable> (<othercolumn>)
> > on update cascade on delete cascade;
>
> IIRC, the constraint will get an automatic name of the form
> $<n> in such cases. I believe if you do a \d on the table,
> it gives the name in the constraint definitions (on one of mine
> i get:
>
> Foreign Key constraints: $1 FOREIGN KEY (a) REFERENCES qqq(a) ON UPDATE
> CASCADE ON DELETE NO ACTION
>
> Where $1 is the name of the constraint.
Thanks. In my 7.2.3 database, the table in question has:
Primary key: watch_list_staging_pkey
Check constraints: "watch_list_stag_from_watch_list"
((from_watch_list = 't'::bool) OR (from_watch_list = 'f'::bool))
"watch_list_stagin_from_pkg_info" ((from_pkg_info
= 't'::bool) OR (from_pkg_info = 'f'::bool))
Triggers: RI_ConstraintTrigger_4278482,
RI_ConstraintTrigger_4278488
No mention of FK constraints.
--
Dan Langille : http://www.langille.org/
From | Date | Subject | |
---|---|---|---|
Next Message | Dan Langille | 2002-12-05 16:51:56 | Re: 7.4 - TODO : alter table drop foreign key |
Previous Message | Stephan Szabo | 2002-12-05 16:44:28 | Re: 7.4 - TODO : alter table drop foreign key |