Skip site navigation (1) Skip section navigation (2)

Bug #616: Alter table add foreign key

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #616: Alter table add foreign key
Date: 2002-03-15 12:24:46
Message-ID: 20020315122446.08F30475990@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Dirk Jacobs (dirk(dot)jacobs(at)tuple(dot)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 that the 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


Responses

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-03-15 12:26:02
Subject: Bug #617: In SQL the tableowner is not allowed
Previous:From: Vadim MikheevDate: 2002-03-15 09:05:33
Subject: Re: Bug #613: Sequence values fall back to previously chec

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group