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
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 |