Re: pgAdmin 4 does not run "create extension" script in the Query Tool

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Adam Benson <adam(dot)benson(at)vacancyfiller(dot)co(dot)uk>
Cc: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: pgAdmin 4 does not run "create extension" script in the Query Tool
Date: 2016-10-18 08:26:02
Message-ID: CA+OCxowgVc10a6szHzXASmRQtZSxFm7mBNLhcrXxYK1g8Kiqzg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi

On Mon, Oct 17, 2016 at 3:34 PM, Adam Benson
<adam(dot)benson(at)vacancyfiller(dot)co(dot)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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2016-10-18 08:27:59 Re: pgAdmin 4 does not run "add column" script in the Query Tool
Previous Message Adam Benson 2016-10-17 14:34:37 pgAdmin 4 does not run "create extension" script in the Query Tool