subject:"\[pgadmin\-support\] Problem createing table with citext"

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

2016-10-18 Thread 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

[pgadmin-support] Problem createing table with citext

2016-10-18 Thread 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) )