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