Re: Problem createing table with citext

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