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

Different error messages executing CREATE TABLE or ALTER TABLE to create a column "xmin"

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

Responses

pgsql-hackers by date

Next:From: Kohei KaiGaiDate: 2012-01-22 14:54:08
Subject: Re: [v9.2] sepgsql's DROP Permission checks
Previous:From: Kohei KaiGaiDate: 2012-01-22 10:57:36
Subject: Re: [v9.2] Fix Leaky View Problem

pgsql-bugs by date

Next:From: arenDate: 2012-01-23 01:08:43
Subject: BUG #6406: Included pgAdmin does not have .sql file extension mapped
Previous:From: mark.phillipsDate: 2012-01-20 21:58:01
Subject: BUG #6405: postgres account not created during unattended install

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