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

[pgadmin-support] pgAdmin 4 does not run "add column" script in the Query Tool

2016-10-18 Thread Adam Benson
Running pgAdmin 4 V 1.0 against PostGres 9.6.0 OS: Windows 7 Pro x64 How to reproduce: Start up pgAdmin4 Connect to your local server. Right-click on "Databases" and select "Create \ Database ..." The "Create - Database" dialog comes up. Enter "Test" as the database name and hit Save. The

Re: [pgadmin-support] pgAdmin 4 does not run "add column" script in the Query Tool

2016-10-18 Thread Dave Page
Hi On Mon, Oct 17, 2016 at 3:28 PM, Adam Benson wrote: > Running pgAdmin 4 V 1.0 against PostGres 9.6.0 > > OS: Windows 7 Pro x64 > > > > How to reproduce: > > > > Start up pgAdmin4 > > Connect to your local server. > > Right-click on "Databases" and select

Re: [pgadmin-support] Cannot launch pgAdmin4

2016-10-18 Thread Dave Page
Hi On Sun, Oct 16, 2016 at 12:23 PM, Laczkóczki Ákos wrote: > I would like to inform you I have successfully fixed the issue. > > Probably the problem was that the name of my user home directory contains > space and special characters. So, the exact path which pgAdmin

Re: [pgadmin-support] pgAdmin 4 does not run "create extension" script in the Query Tool

2016-10-18 Thread Dave Page
Hi On Mon, Oct 17, 2016 at 3:34 PM, Adam Benson wrote: > Running pgAdmin 4 V 1.0 against PostGres 9.6.0 > > OS: Windows 7 Pro x64 > > > > How to reproduce: > > > > Start up pgAdmin4 > > Connect to your local server. > > Right-click on "Databases" and select

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] pgAdmin 4 does not run "create extension" script in the Query Tool

2016-10-18 Thread Adam Benson
Running pgAdmin 4 V 1.0 against PostGres 9.6.0 OS: Windows 7 Pro x64 How to reproduce: Start up pgAdmin4 Connect to your local server. Right-click on "Databases" and select "Create \ Database ..." The "Create - Database" dialog comes up. Enter "Test" as the database name and hit Save. The