Re: Bug #616: Alter table add foreign key

From: Stefano Reksten <sreksten(at)sdb(dot)it>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #616: Alter table add foreign key
Date: 2002-03-15 12:39:29
Message-ID: 5.1.0.14.2.20020315133511.00a11600@rfi1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message 'Ben Grimm' 2002-03-15 13:23:58 Re: Bug #613: Sequence values fall back to previously chec
Previous Message pgsql-bugs 2002-03-15 12:36:24 Bug #619: Not possible to specify foreign key name