Re: postgresql system column errors

From: Mark Gibson <gibsonm(at)cromwell(dot)co(dot)uk>
To: Ashish Mahabal <aam(at)astro(dot)caltech(dot)edu>
Cc: Inoue(at)tpf(dot)co(dot)jp, pgsql-general(at)postgresql(dot)org
Subject: Re: postgresql system column errors
Date: 2004-02-16 13:54:24
Message-ID: 4030CB90.6070204@cromwell.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fischer Ulrich 2004-02-16 13:57:47 tsearch2: restoring problem
Previous Message Robert Creager 2004-02-16 12:58:33 Re: Dazed and Confused