BUG #5286: pgAdmin will put table and field names in apostrophes which then must be used for accessing them
От | G.Schaeffler |
---|---|
Тема | BUG #5286: pgAdmin will put table and field names in apostrophes which then must be used for accessing them |
Дата | |
Msg-id | 201001181103.o0IB3sth028745@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #5286: pgAdmin will put table and field names in
apostrophes which then must be used for accessing them
Re: BUG #5286: pgAdmin will put table and field names in apostrophes which then must be used for accessing them |
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 5286 Logged by: G.Schaeffler Email address: scgn@sie.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.
В списке pgsql-bugs по дате отправления: