On Mon, Oct 17, 2016 at 11:05 AM, Johann Spies <jsp...@sun.ac.za> wrote: > When I try to create a table using the gui, it generates this definition > which fails: > > CREATE TABLE o.r_url > ( > id bigserial NOT NULL, > orc character varying(19) NOT NULL, > ex_id_com_name "public.citext", > ex_id_ref "public.citext", > ex_id_url "public.citext", > PRIMARY KEY (orc) > ) > WITH ( > OIDS = FALSE > ) > > After removing the quotes from "public.citext" the query succedds when > run in the querytool or in psql.
Thanks, logged here: https://redmine.postgresql.org/issues/1863 -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support