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 |
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" |
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 |