The following bug has been logged online:
Bug reference: 1570
Logged by: Christopher Brian Jurado
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: Windows 2000
Description: Double quotes in all field/table names must be optional!
Details:
The double quote(") for field/table names doesn't seem to be optional when
using it in queries.
I used pgAdmin under verion 8.0 to query any field on any table. A message
says the relation does not exist. If I double-quote the field names and
table names, then it works. Isn't it a very big burden to keep typing double
quotes?
I tried searching through the postgresql.conf file but nothing is there to
control this behavior.
In the documentation, they show samples without double quotes but it
actually doesn't work when you try it.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
