Re: postgresql system column errors

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.