Hi Marc, On Mon, Jan 23, 2012 at 3:04 PM, Vik Reykja <vikrey...@gmail.com> wrote: > On Mon, Jan 23, 2012 at 11:25, Marc Balmer <m...@msys.ch> wrote: >> >> Am 22.01.12 14:22, schrieb Giuseppe Sucameli: >> > test=> create table lx (i int); >> > CREATE TABLE >> > test=> alter table lx add xmin int; >> > ERROR: column "xmin" of relation "lx" already exists. >> >> That is not a bug, but a feature. > > I see it as a message bug. Why wouldn't ALTER TABLE also tell us that xmin > is a system column? It makes things much more clear for newbies who don't > see the column yet are told it exists if they're also told it's a system > column.
I agree with Vik, the CREATE TABLE tells "xmin" is a system column, why wouldn't ALTER TABLE do the same? This would be a feature if CREATE TABLE didn't tell us that xmin is a system column, otherwise is a bug. > I would try to cook up a patch but I have no skills :-( I'm going to write a patch to fix this problem. Regards. -- Giuseppe Sucameli -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs