Re: [pgadmin-support] Problem createing table with citext

[Dave Page]

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


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] Problem createing table with citext

[Johann Spies]

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 SpiesTelefoon: 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 vertroulikheid van hierdie epos. 
http://www.sun.ac.za/emaildisclaimer


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support