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

ALTER TABLE Problem

From: dirk(dot)jacobs(at)tuple(dot)be
To: pgsql-bugs(at)postgresql(dot)org
Subject: ALTER TABLE Problem
Date: 2002-03-15 12:26:55
Message-ID: OFB1290811.1351ED72-ON41256B7D.0043FB99@tuple.be (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi,

- 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

- I also tried some ODBC stuff. Here I've seen that the S.... result codes 
are not correct. Most of the time it simply return S1000 which is a 
general error code.

and not a specific code. e.g. when you want to create a table that already 
exists it should return the correct error. ( same for an index, etc... )


Regards,


Dirk Jacobs



pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-03-15 12:27:18
Subject: Bug #618: Incorrect error codes
Previous:From: pgsql-bugsDate: 2002-03-15 12:26:02
Subject: Bug #617: In SQL the tableowner is not allowed

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