Re: Contrib, schema, and load_module

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Contrib, schema, and load_module
Date: 2008-10-11 19:10:05
Message-ID: 48F0FA0D.30902@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom,

> Yeah. If the schema-per-module answer were really a good answer,
> we'd have done it before now. But you need more infrastructure
> than just a schema to get good things to happen. Aside from the
> search-path-hell issue, a schema alone doesn't solve the problem
> of persuading pg_dump to dump a "load module" command rather than
> the individual module components.

I have faith in nothing historical regarding /contrib, which has been
largely characterized by maintenance neglect.

However, it sounds like waiting for something like Dimitri's package
manager is the way to go rather than messing with schemas without other
instruments in place. I'll just go through and replace the BEGIN ...
COMMITS in the SQL scripts, which Bruce admits he deleted without really
thinking about it.

--Josh

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2008-10-11 19:10:48 Re: Contrib, schema, and load_module
Previous Message Josh Berkus 2008-10-11 19:06:54 Re: WITH RECURSIVE ... simplified syntax?