Обсуждение: pgAdmin 4 does not run "add column" script in the Query Tool

<div class="WordSection1"><p class="MsoNormal">Running pgAdmin 4 V 1.0 against PostGres 9.6.0<p class="MsoNormal">OS:
Windows7 Pro x64<p class="MsoNormal"> <p class="MsoNormal">How to reproduce:<p class="MsoNormal"> <p
class="MsoNormal">Startup pgAdmin4<p class="MsoNormal">Connect to your local server.<p class="MsoNormal">Right-click on
"Databases"and select "Create \ Database ..."<p class="MsoNormal">The "Create - Database" dialog comes up.<p
class="MsoNormal">Enter"Test" as the database name and hit Save.<p class="MsoNormal">The database is created.<p
class="MsoNormal"> <pclass="MsoNormal">Navigate to "Test\Schemas\public\Tables"<p class="MsoNormal">Right-click on
"Tables"and select "Create\Table"<p class="MsoNormal">The "Create - Table" dialog comes up.<p class="MsoNormal">Enter
"TestTable"as the table name and hit Save.<p class="MsoNormal">The table is created.<p class="MsoNormal"> <p
class="MsoNormal">Right-clickon database "Test" and select "Query Tool"<p class="MsoNormal">In the query window
enter:<pclass="MsoNormal"> <p class="MsoNormal">   ALTER TABLE "TestTable"<p class="MsoNormal">   ADD COLUMN "A"
text;<pclass="MsoNormal"> <p class="MsoNormal">Hit F5.<p class="MsoNormal">The "Messages" section contains:<p
class="MsoNormal"> <pclass="MsoNormal">  ALTER TABLE<p class="MsoNormal"> <p class="MsoNormal">  Query returned
successfullyin 145 msec.<p class="MsoNormal"> <p class="MsoNormal">Right-click on
"Test\Schemas\public\Tables\TestTable\Columns"and select "Refresh"<p class="MsoNormal">Column "A" has not been added.<p
class="MsoNormal"> <pclass="MsoNormal">If you restart pgAdmin the column is still not there.<p class="MsoNormal"> <p
class="MsoNormal">ManyThanks,<p class="MsoNormal"> <p class="MsoNormal">Adam Benson<p
class="MsoNormal">==================<pclass="MsoNormal"> </div> 

Hi

On Mon, Oct 17, 2016 at 3:28 PM, Adam Benson
<adam.benson@vacancyfiller.co.uk> 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 "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.

I can't reproduce this one either - in fact, I don't even need to hit
Refresh on the Columns node as it hasn't been populated at that point;
it immediately picks up the new node when opened.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company