Problem createing table with citext

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

Responses

Browse pgadmin-support by date

  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