Обсуждение: Problem createing table with citext

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
 

On Mon, Oct 17, 2016 at 11:05 AM, Johann Spies <jspies@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