Re: postgresql system column errors

Thanx Mark.

Thats what I ended up doing. But it seems silly that the name space for
system columns and user columns are not separate. Its just like saying
that you can not have the same column name in 2 different tables.

Just like I can say table1.myCol and table2.myCol, there should have been
a way to say system.xmin and myTable.xmin, the default being myTable.xmin
when I am doing stuff with myTable. Whereever xmin gets used currently,
the source could explicitely say system.xmin. Anyway. hope that is done in
some future version.

Cheers,
-ashish

On Mon, 16 Feb 2004, Mark Gibson wrote:

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

Ashish Mahabal, Caltech Astronomy, Pasadena, CA 91125
http://www.astro.caltech.edu/~aam aam(at)astro(dot)caltech(dot)edu

"Alcohol and calculus don't mix. Never drink and derive."