Re: Add CREATE EXTENSION Support

From: Dave Page <dpage(at)pgadmin(dot)org>
To: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Add CREATE EXTENSION Support
Date: 2014-01-13 09:30:16
Message-ID: CA+OCxoyiBtv8xY9tqDo7=B6q0anx0ddr9YMQ1G3jyQaUm02JdQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

On Sat, Jan 11, 2014 at 10:01 PM, David E. Wheeler
<david(at)justatheory(dot)com> wrote:
> PGAdmin Hackers,
>
> I’d like to add code to pgAgent so that its schema could be installed via a CREATE EXTENSION statement. This would greatly simplify deployment for us. In private correspondence, Dave Page suggested that CMake be updated to handle it. At a glance, I think I'd have to move things around a bit, perhaps create an SQL directory, and have CMake concatenate files (or wrap them in BEGIN/COMMIT statements) to generate the old file. Does that make sense?

Yes.

> Also, is there access to PGXS during the build? I'm pretty familiar with how PostgreSQL extension Makefiles should work, but not the configure/CMake stuff in pgAdmin. Pointers would be appreciated.

PGXS cannot be used - it doesn't support Windows.

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

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

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message David E. Wheeler 2014-01-13 17:13:44 Re: Add CREATE EXTENSION Support
Previous Message Dave Page 2014-01-13 09:27:27 Re: [PATCH] Add a menu option for disabling restoration of previous environment on reconnect