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

From pgsql-bugs@postgresql.org
Subject Bug #616: Alter table add foreign key
Date
Msg-id 20020315122446.08F30475990@postgresql.org
Whole thread Raw
Responses Re: Bug #616: Alter table add foreign key
List pgsql-bugs
Dirk Jacobs (dirk.jacobs@tuple.be) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
Alter table add foreign key

Long Description
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
thatthe column exists and is Non null. I'm using version 7.2 on linux redhat 7.2
 


Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: 'Ben Grimm'
Date:
Subject: Re: Bug #613: Sequence values fall back to previously chec
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #617: In SQL the tableowner is not allowed