advice for user column named cmin - Mailing list pgsql-hackers

From Hannu Krosing
Subject advice for user column named cmin
Date
Msg-id 1026730000.29268.24.camel@taru.tm.ee
Whole thread Raw
List 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




pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: More DROP COLUMN
Next
From: Curt Sampson
Date:
Subject: Re: More DROP COLUMN