Обсуждение: pgAdmin 4 does not run "create extension" 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">Rightclick on the new table and select "Query Tool"<p class="MsoNormal">In the query window enter:<p
class="MsoNormal"> <pclass="MsoNormal">   create extension "citext"<p class="MsoNormal"> <p class="MsoNormal">Hit F5<p
class="MsoNormal">Themessages window contains this:<p class="MsoNormal"> <p class="MsoNormal">   CREATE EXTENSION<p
class="MsoNormal"> <pclass="MsoNormal">   Query returned successfully in 161 msec.<p class="MsoNormal"> <p
class="MsoNormal">Right-click"Test\Extensions" and select "Refresh"<p class="MsoNormal"> <p class="MsoNormal">BUG: The
citextextension is not there.<p class="MsoNormal"> <p class="MsoNormal">If you restart pgAdmin 4 the extension is still
notthere.<p class="MsoNormal"> <p class="MsoNormal">Thanks,<p class="MsoNormal"> <p class="MsoNormal">Adam Benson<p
class="MsoNormal">==================</div>

Hi

On Mon, Oct 17, 2016 at 3:34 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 the new table and select "Query Tool"
>
> In the query window enter:
>
>
>
>    create extension "citext"
>
>
>
> Hit F5
>
> The messages window contains this:
>
>
>
>    CREATE EXTENSION
>
>
>
>    Query returned successfully in 161 msec.
>
>
>
> Right-click "Test\Extensions" and select "Refresh"
>
>
>
> BUG: The citext extension is not there.
>
>
>
> If you restart pgAdmin 4 the extension is still not there.

I cannot reproduce this with 9.6.0 and 1.0 on Windows 7, or with 9.4
on macOS with the latest pgAdmin code from git. In both cases, the
extension is shown as soon as I hit refresh.

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

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