From: | Hannu Krosing <hannu(at)tm(dot)ee> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
Cc: | PostgreSQL HACKERS <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: is there a way to DROP foreign key constraint ? |
Date: | 2000-10-22 22:01:17 |
Message-ID: | 39F363AD.370B9E62@tm.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Stephan Szabo wrote:
>
> On Fri, 20 Oct 2000, Hannu Krosing wrote:
>
> > I'm unable to find the complementary function to
> >
> > ALTER TABLE t ADD FOREIGN KEY(id) REFERENCES pkt(pk);
>
> Currently, ALTER TABLE ... DROP table constraint definition
> doesn't exist.
>
> > I would try DROP TRIGGER, but I've also been unable to
> > find a way to name the constraint ;(
>
> Umm, put the constraint name in the table constraint definition?
> >From the SQL spec:
> <table constraint definition> ::=
> [ <constraint name definition> ]
> <table constraint> [ <constraint attributes> ]
> <constraint name definition> ::= CONSTRAINT <constraint name>
Thanks! I was missing the CONSTRAINT word in <constraint name
definition>
------------
Hannu
From | Date | Subject | |
---|---|---|---|
Next Message | Larry Rosenman | 2000-10-22 23:20:47 | AnonCVS access? |
Previous Message | Tom Lane | 2000-10-22 19:21:59 | Re: Re: [HACKERS] to_char() dumps core |