G.Schaeffler wrote: > 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.
Does your table name have uppercase chars? If it has, that's probably the reason the name doesn't work unless quoted. This is expected behavior for identifiers. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
