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-hackers(at)postgresql(dot)org
Subject: Different error messages executing CREATE TABLE or ALTER TABLE to create a column "xmin"
Date: 2012-01-24 14:10:48
Message-ID: CAA6k8-+E_0mAFqt82UrS4CJOW8s5=R5Jp6tKKb1a_-_nUtWgYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Hi hackers,

the attached patch fixes the problem I explained in pgsql-bugs (forwarded).
It's a trivial problem, so no initial patch design was required.

Hope to see my patch applied.
Thanks for your work.

Regards.

---------- Forwarded message ----------
From: Giuseppe Sucameli <brush(dot)tyler(at)gmail(dot)com>
Date: Sun, Jan 22, 2012 at 2:22 PM
Subject: Different error messages executing CREATE TABLE or ALTER
TABLE to create a column "xmin"
To: pgsql-bugs(at)postgresql(dot)org

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

--
Giuseppe Sucameli

Attachment Content-Type Size
postgresql_syscol_message.diff application/octet-stream 2.8 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Phil Sorber 2012-01-24 20:22:45 Re: Segfault in backend CTE code
Previous Message Giuseppe Sucameli 2012-01-24 13:41:56 Re: Different error messages executing CREATE TABLE or ALTER TABLE to create a column "xmin"

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2012-01-24 14:26:59 Re: GUC_REPORT for protocol tunables was: Re: Optimize binary serialization format of arrays with fixed size elements
Previous Message Robert Haas 2012-01-24 13:58:58 Re: basic pgbench runs with various performance-related patches