Thread: 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