pgAdmin 4 does not run "add column" script in the Query Tool
От | Adam Benson |
---|---|
Тема | pgAdmin 4 does not run "add column" script in the Query Tool |
Дата | |
Msg-id | HE1PR02MB12929D06EDD07B808A1B62D3ADD00@HE1PR02MB1292.eurprd02.prod.outlook.com обсуждение исходный текст |
Ответы |
Re: pgAdmin 4 does not run "add column" script in
the Query Tool
|
Список | pgadmin-support |
<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>
В списке pgadmin-support по дате отправления: