Re: Problem createing table with citext

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