Обсуждение: pgAdmin 4 does not run "create extension" script in the Query Tool

Поиск
Список
Период
Сортировка

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

От
Adam Benson
Дата:

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.

 

Thanks,

 

Adam Benson

==================

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

От
Dave Page
Дата:
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