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.
Regards
Johann
--
Johann Spies Telefoon: 021-808 4699
Databestuurder / Data manager Faks: 021-883 3691
Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology
Universiteit Stellenbosch.
The integrity and confidentiality of this email is governed by these terms / Hierdie terme bepaal die integriteit en
vertroulikheidvan hierdie epos. http://www.sun.ac.za/emaildisclaimer