From: | Giuseppe Sucameli <brush(dot)tyler(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Different error messages executing CREATE TABLE or ALTER TABLE to create a column "xmin" |
Date: | 2012-01-22 13:22:06 |
Message-ID: | CAA6k8-LSvJ8jGpJd2gUr6W47KkCuvy23fo3bzqCsmFP0BMoAUA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
Hi all,
trying to create a table with a column xmin I get the
following error message:
test=> create table lx (xmin int);
ERROR: column name "xmin" conflicts with a system
column name
Instead I get a different (and less understandable) error
message if I try to add a column named xmin to an
existent table:
test=> create table lx (i int);
CREATE TABLE
test=> alter table lx add xmin int;
ERROR: column "xmin" of relation "lx" already exists.
The same problem occurs using "xmax" as column name.
I'm on Ubuntu 11.04.
Tried on both PostgreSQL 8.4.10 and 9.1.2
Regards.
--
Giuseppe Sucameli
From | Date | Subject | |
---|---|---|---|
Next Message | aren | 2012-01-23 01:08:43 | BUG #6406: Included pgAdmin does not have .sql file extension mapped |
Previous Message | mark.phillips | 2012-01-20 21:58:01 | BUG #6405: postgres account not created during unattended install |
From | Date | Subject | |
---|---|---|---|
Next Message | Kohei KaiGai | 2012-01-22 14:54:08 | Re: [v9.2] sepgsql's DROP Permission checks |
Previous Message | Kohei KaiGai | 2012-01-22 10:57:36 | Re: [v9.2] Fix Leaky View Problem |