Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TABLE problems - Mailing list pgsql-bugs

From Tom Lane
Subject Re: ALTER TABLE problems
Date
Msg-id 22601.1050898805@sss.pgh.pa.us
Whole thread Raw
In response to ALTER TABLE problems  (Ruslan A Dautkhanov <rusland@scn.ru>)
List pgsql-bugs
Tree view 
Ruslan A Dautkhanov <rusland@scn.ru> writes:
> I had found today that when I tries to add column to a table with
> simultaneous creating foreign key for this column, no constraints
> really created with no any errors messages, but a column really
> added.

Yeah, this is a known bug in 7.3.*: ALTER TABLE ADD COLUMN fails to
process REFERENCES clauses.  There is a fix in place for 7.3.3.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Ruslan A Dautkhanov
Date:
Subject: ALTER TABLE problems
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #951: Creating table fails if inherited table has no columns.