BUG #1570: Double quotes in all field/table names must be optional!

From: "Christopher Brian Jurado" <cbjurado(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1570: Double quotes in all field/table names must be optional!
Date: 2005-03-30 07:03:40
Message-ID: 20050330070340.571E0F0C73@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1570
Logged by: Christopher Brian Jurado
Email address: cbjurado(at)yahoo(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2005-03-30 14:58:06 Re: BUG #1567: can't hide password with pg_autovacuum
Previous Message Bruce Momjian 2005-03-30 06:35:40 Re: [BUGS] Enhancement: Remove NT/Interactive from Power Users Group