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 по дате отправления:

Предыдущее
От: Johann Spies
Дата:
Сообщение: Problem createing table with citext
Следующее
От: Adam Benson
Дата:
Сообщение: pgAdmin 4 does not run "create extension" script in the Query Tool