BUG #1570: Double quotes in all field/table names must be optional! - Mailing list pgsql-bugs

From Christopher Brian Jurado
Subject BUG #1570: Double quotes in all field/table names must be optional!
Date
Msg-id 20050330070340.571E0F0C73@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1570: Double quotes in all field/table names must be
List pgsql-bugs
The following bug has been logged online:

Bug reference:      1570
Logged by:          Christopher Brian Jurado
Email address:      cbjurado@yahoo.com
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.

pgsql-bugs by date:

Previous
From: "rajkumar"
Date:
Subject: BUG #1574: plpgsql
Next
From: Olivier Thauvin
Date:
Subject: Re: BUG #1567: can't hide password with pg_autovacuum