On Wed, Sep 26, 2012 at 5:36 PM, Dimitri Fontaine
<dimitri@2ndquadrant.fr> wrote:
> After much distractions I've at least been able to do something about
> that bug report.
Thanks.
>> 2) If there is schema with functions, but nothing else,
>> create extension pgq_coop from 'unpackaged';
>> drop extension pgq_coop;
>> create extension pgq_coop;
>> ERROR: schema "pgq_coop" already exists
>
> From reading the scripts, it's not clear to me, but it appears that the
> schema existed before the create from unpackaged then got added to the
> extension by way of
>
> ALTER EXTENSION pgq_coop ADD SCHEMA pgq_coop;
>
> Is that true?
Yes.
> Can we work out a minimal example to reproduce the bug?
Yes, the above text or sql/pgq_coop/sql/pgq_coop_init_ext.sql
I guess you could replace pgq_coop with any extension just
consisting of just functions.
> (The Makefile in skytools/sql/pgq_coop fails on my OS)
How does it fail? Are you using gnu make? What version?
--
marko