Re: SV: [GENERAL] Table whose name has Capital letters

2000-11-24 Thread Peter Eisentraut
Jarmo Paavilainen writes: > PS: Im thinking of making a own hack of pg where selects are case sensitive > (ie Nov2000 and "Nov2000" are the same). If someone is interested, Ill > upload the diff somewhere. DS. Not that I particularly approve of this plan ;-) but look for tolower() calls in src/b

SV: [GENERAL] Table whose name has Capital letters

2000-11-24 Thread Jarmo Paavilainen
Hi, ... > I have created a table with the name 'Nov2000' and now it is impossible to > access it, because psql is always searching for the table 'nov2000'. Put the table name inside quotes. ie: SELECT FROM "Nov2000" _not_ SELECT FROM Nov2000 ... > Have I done something wrong or is it a bug ? I

[GENERAL] Table whose name has Capital letters

2000-11-24 Thread Gabriel Fernandez
Hi , I have created a table with the name 'Nov2000' and now it is impossible to access it, because psql is always searching for the table 'nov2000'. The only solution I have found is to manually modify the pg_class table and the name of the physical file associated to the table. Have I done som