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

From: Adam Benson <adam(dot)benson(at)vacancyfiller(dot)co(dot)uk>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: pgAdmin 4 does not run "create extension" script in the Query Tool
Date: 2016-10-17 14:34:37
Message-ID: HE1PR02MB12920F91E2B8E85B1BB5D4E0ADD00@HE1PR02MB1292.eurprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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
==================

Responses

Browse pgadmin-support by date

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