pgAdmin 4 does not run "add column" script in the Query Tool

From: Adam Benson <adam(dot)benson(at)vacancyfiller(dot)co(dot)uk>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: pgAdmin 4 does not run "add column" script in the Query Tool
Date: 2016-10-17 14:28:11
Message-ID: HE1PR02MB12929D06EDD07B808A1B62D3ADD00@HE1PR02MB1292.eurprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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 database is created.

Navigate to "Test\Schemas\public\Tables"
Right-click on "Tables" and select "Create\Table"
The "Create - Table" dialog comes up.
Enter "TestTable" as the table name and hit Save.
The table is created.

Right-click on database "Test" and select "Query Tool"
In the query window enter:

ALTER TABLE "TestTable"
ADD COLUMN "A" text;

Hit F5.
The "Messages" section contains:

ALTER TABLE

Query returned successfully in 145 msec.

Right-click on "Test\Schemas\public\Tables\TestTable\Columns" and select "Refresh"
Column "A" has not been added.

If you restart pgAdmin the column is still not there.

Many Thanks,

Adam Benson
==================

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Adam Benson 2016-10-17 14:34:37 pgAdmin 4 does not run "create extension" script in the Query Tool
Previous Message Johann Spies 2016-10-17 10:05:04 Problem createing table with citext