BUG #5286: pgAdmin will put table and field names in apostrophes which then must be used for accessing them

From: "G(dot)Schaeffler" <scgn(at)sie(dot)at>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5286: pgAdmin will put table and field names in apostrophes which then must be used for accessing them
Date: 2010-01-18 11:03:54
Message-ID: 201001181103.o0IB3sth028745@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5286
Logged by: G.Schaeffler
Email address: scgn(at)sie(dot)at
PostgreSQL version: 8.4.2
Operating system: windows server 2003 std
Description: pgAdmin will put table and field names in apostrophes
which then must be used for accessing them
Details:

if i create a table by using the pgadmin gui, it will create statements
like
CREATE TABLE "t_test" (
id integer,
"val" character varying(1000) NOT NULL );
after creation, i can only access the table again if i wrap the apostrophes
around the table and field names as in the create table statement.

ie.
SELECT * from t_test; will return ERROR: Relation t_test does not exit
SELECT val from "t_test" will return ERROR: field val does not exist.

when using the following sql statement
select * from information_schema.tables where table_schema='public' and
table_type='BASE TABLE'
to get the tablename as it is saved in the db, it will return t_test, not
"t_test" though.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alpha Softwares Solutions 2010-01-18 13:20:14 Questions
Previous Message heyong 2010-01-18 10:13:31 BUG #5285: contrib\xml2 package's xpath_table function