Re: [9.1] 2 bugs with extensions - Mailing list pgsql-hackers

From Marko Kreen
Subject Re: [9.1] 2 bugs with extensions
Date
Msg-id CACMqXCLDLAyDKRhWuHvssH0phQwmbFrXg=m-GeFvcLSs3wR=aA@mail.gmail.com
Whole thread Raw
In response to Re: [9.1] 2 bugs with extensions  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Responses Re: [9.1] 2 bugs with extensions
List pgsql-hackers
On Wed, Sep 26, 2012 at 7:15 PM, Dimitri Fontaine
<dimitri@2ndquadrant.fr> wrote:
> Marko Kreen <markokr@gmail.com> writes:
>>> 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.
>
> I did just that, with a single function, and couldn't reproduce the
> problem either in 9.1 nor in master, with relocatable = true then with
> relocatable = false and schema = 'pg_catalog' as in your repository.

Indeed, after another makefile reorg, I could not reproduce it
on skytools master either, some digging showed that due
to a makefile bug ($< instead $^) the ADD SCHEMA
was missing from .sql file.  So no bug in postgres.

>>> (The Makefile in skytools/sql/pgq_coop fails on my OS)
>>
>> How does it fail?  Are you using gnu make?  What version?
>
> I guess sed is the problem here, it's a BSD variant:

Could you test if Skytools git now works for you?

I replaced sed usage with awk there, perhaps that will be
more portable.

-- 
marko



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Re: [WIP] Performance Improvement by reducing WAL for Update Operation
Next
From: Tom Lane
Date:
Subject: Re: setting per-database/role parameters checks them against wrong context