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

From Adam Benson
Subject pgAdmin 4 does not run "add column" script in the Query Tool
Date
Msg-id HE1PR02MB12929D06EDD07B808A1B62D3ADD00@HE1PR02MB1292.eurprd02.prod.outlook.com
Whole thread Raw
Responses Re: pgAdmin 4 does not run "add column" script in the Query Tool
List 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

==================

 

pgadmin-support by date:

Previous
From: Johann Spies
Date:
Subject: Problem createing table with citext
Next
From: Adam Benson
Date:
Subject: pgAdmin 4 does not run "create extension" script in the Query Tool