advice for user column named cmin

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: advice for user column named cmin
Date: 2002-07-15 10:46:40
Message-ID: 1026730000.29268.24.camel@taru.tm.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I'm trying to use a closed source program with PostgreSQL over ODBC

The problem is that it tries to make a table which has a column called
'cmin' which of course not allowes.

Are there any plans of either

1) (optionally) renaming such sytem columns in the ODBC layer

2) renaming system colums to start with pg_ (pg_oid, pg_cmin, pg_*)

3) moving them to another namespace, accessible like a schema

so

select oid from mytable;

would become

select system.oid from mytable;

I quess that SQL is not as flexible as XML in putting anything in its
own namespace ;(

---------------
Hannu

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Haworth 2002-07-15 11:12:08 Re: Jan's Name (Was: Re: I am being interviewed by OReilly)
Previous Message Curt Sampson 2002-07-15 10:35:59 Re: More DROP COLUMN