From: | Johann Spies <jspies(at)sun(dot)ac(dot)za> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Problem createing table with citext |
Date: | 2016-10-17 10:05:04 |
Message-ID: | 20161017100504.4dklajgoviavhrer@sun.ac.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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 vertroulikheid van hierdie epos. http://www.sun.ac.za/emaildisclaimer
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Benson | 2016-10-17 14:28:11 | pgAdmin 4 does not run "add column" script in the Query Tool |
Previous Message | Laczkóczki Ákos | 2016-10-16 11:23:53 | Re: Cannot launch pgAdmin4 |