[HACKERS] default lower case of identifier

2006-07-26 Thread jkzhao



Dear hackers,
 
    I am migrating an application program 
from Oracle to PostgreSQL, but one problem blocks me.
 
    According to SQL92 standard, in 
Oracle, identifiers that are not double quoted are changed to upper 
case.
 
    But, in PostgreSQL, 
identifiers that are not double quoted are changed to lower 
case.
 
    So, create user "HU", 
then connect Oracle by  HU  is right;
 
    But, create user "HU" then 
connect PostgreSQL by HU is wrong.
 
    My application program is very long 
and has many such errors.
 
    I'd like to know whether I can make 
PostgreSQL stands to the SQL92 standard by changing some PostgreSQL's 
code?
 
    Thanks & Best 
Regards.



JK. zhao
2006-07-26


[HACKERS] column-level privilege

2006-07-25 Thread jkzhao



Dear hackers,
 
    I am a PostgreSQL lover at China, I'd 
like to know when the column-level privilege can be added to a release version 
of PostgreSQL? and is there someone who is working on the problem?
 
    Thanks & Best Regards.
 



jkzhao
2006-07-25