Re: ALTER TABLE problems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ruslan A Dautkhanov <rusland(at)scn(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: ALTER TABLE problems
Date: 2003-04-21 04:20:05
Message-ID: 22601.1050898805@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Ruslan A Dautkhanov <rusland(at)scn(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message bmp 2003-04-21 08:06:58 Primary key violation
Previous Message Ruslan A Dautkhanov 2003-04-21 04:04:58 ALTER TABLE problems