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
==================
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 |