Re: postgresql system column errors - Mailing list pgsql-general

From Mark Gibson
Subject Re: postgresql system column errors
Date
Msg-id 4030CB90.6070204@cromwell.co.uk
Whole thread Raw
In response to postgresql system column errors  (Ashish Mahabal <aam@astro.caltech.edu>)
Responses PGSQL C API()  (Karam Chand <karam_chand03@yahoo.com>)
Re: postgresql system column errors  (Ashish Mahabal <aam@astro.caltech.edu>)
List pgsql-general
Ashish Mahabal wrote:

>Hello Hiroshi,
>
>When I try to use the column name xmin in one of my tables I get
>ERROR:  column name "xmin" conflicts with a system column name
>
>You seem to have been affected by these errors in the past too. Had you
>found a solution?
>
>Anybody else have any solutions?
>
>

The only thing you can do is change your column name.

The manual tells you about the system columns here:
http://www.postgresql.org/docs/7.4/static/ddl-system-columns.html

--
Mark Gibson <gibsonm |AT| cromwell |DOT| co |DOT| uk>
Web Developer & Database Admin
Cromwell Tools Ltd.
Leicester, England.


pgsql-general by date:

Previous
From: Robert Creager
Date:
Subject: Re: Dazed and Confused
Next
From: Fischer Ulrich
Date:
Subject: tsearch2: restoring problem