Re: postgresql system column errors

On Tue, Feb 17, 2004 at 11:15:13AM -0800, Ashish Mahabal wrote:
>
> 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.

I think you're missing something. Every table has the xmin, xmax, cmin, cmax
and sometimes oid columns. They're not only in the system tables. These
columns are what makes transactions work and they exist for every record.

I hope you're not suggesting a move to myTable.system.xmin ?

Pick a table and do: select xmin,xmax,cmin,cmax from <table>

What you're asking is to have the same column name twice in a single table,
which is obviously silly.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> If the Catholic church can survive the printing press, science fiction
> will certainly weather the advent of bookwarez.
> http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow