Re: Problem createing table with citext

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Johann Spies <jspies(at)sun(dot)ac(dot)za>, pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Problem createing table with citext
Date: 2016-10-18 08:32:25
Message-ID: CA+OCxowkqkZJbC5HggMQQopH=Z1pMnXDgB8tQ00JZovuDgsH7A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Mon, Oct 17, 2016 at 11:05 AM, Johann Spies <jspies(at)sun(dot)ac(dot)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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2016-10-18 08:49:56 Re: Cannot launch pgAdmin4
Previous Message Dave Page 2016-10-18 08:27:59 Re: pgAdmin 4 does not run "add column" script in the Query Tool