Re: Bug #616: Alter table add foreign key - Mailing list pgsql-bugs

At 07.24 15/03/02 -0500, you wrote:
>I tried to execute following SQL alter table PRICEGROUP add FOREIGN
>KEY  ("PARENT") REFERENCES "PRICEGROUP" ON DELETE CASCADE
>
>this gives an error ALTER TABLE: column "PARENT" referenced in foreign key
>constraint does not exist (7) while I'm sure that the column exists and is
>Non null. I'm using version 7.2 on linux redhat 7.2

Hello Dirk,
if you are using double quotes around the column name the name won't be
translated in lowercase; maybe the column name wasn't created this way and
that's why you caon't find it. Try to
alter table pricegroup add foreign key (parent) references pricegroup on
delete cascade
without using double quotes.

Just my 0.02

Ciao,
         Stefano