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
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
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