Re: [HACKERS] Contrib, schema, and load_module

2008-10-11 Thread Dimitri Fontaine
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Le 11 oct. 08 à 21:10, Josh Berkus a écrit : Am I correct in assuming, however, that you're not at all likely to complete this for 8.4? Not only that, but as I've yet to discover PostgreSQL internal code, it would ask a lot of help and effo

Re: [HACKERS] Contrib, schema, and load_module

2008-10-11 Thread Josh Berkus
Dimitri, Am I correct in assuming, however, that you're not at all likely to complete this for 8.4? --Josh -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Contrib, schema, and load_module

2008-10-11 Thread Josh Berkus
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

Re: [HACKERS] Contrib, schema, and load_module

2008-10-11 Thread Pavel Stehule
2008/10/11 Dimitri Fontaine <[EMAIL PROTECTED]>: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi, > > Le 11 oct. 08 à 01:50, Tom Lane a écrit : >> >> Alvaro Herrera <[EMAIL PROTECTED]> writes: >>> >>> It seems that the real way forward is to improve on that patch. >> >> Yeah. If the schem

Re: [HACKERS] Contrib, schema, and load_module

2008-10-11 Thread Dimitri Fontaine
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Le 11 oct. 08 à 01:50, Tom Lane a écrit : Alvaro Herrera <[EMAIL PROTECTED]> writes: It seems that the real way forward is to improve on that patch. Yeah. If the schema-per-module answer were really a good answer, we'd have done it before no

Re: [HACKERS] Contrib, schema, and load_module

2008-10-10 Thread Alvaro Herrera
Josh Berkus wrote: > But Tom hasn't done anything since April? That's what I'm asking. What's the surprise? I gathered that Tom is itinerant. If he's not here and we want to job to be done, somebody else must do it. -- Alvaro Herrerahttp://www.CommandPrompt.co

Re: [HACKERS] Contrib, schema, and load_module

2008-10-10 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > It seems that the real way forward is to improve on that patch. 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 fro

Re: [HACKERS] Contrib, schema, and load_module

2008-10-10 Thread Josh Berkus
Alvaro Herrera wrote: Josh Berkus wrote: 3) what work was actually done on load_module() by Tom Dunstan, which might make this unnecessary? http://archives.postgresql.org/message-id/[EMAIL PROTECTED] This link appears on Todo: Improve the module installation experience (/contrib, etc)

Re: [HACKERS] Contrib, schema, and load_module

2008-10-10 Thread Alvaro Herrera
Josh Berkus wrote: > 3) what work was actually done on load_module() by Tom Dunstan, which > might make this unnecessary? http://archives.postgresql.org/message-id/[EMAIL PROTECTED] This link appears on Todo: Improve the module installation experience (/contrib, etc) * modules

[HACKERS] Contrib, schema, and load_module

2008-10-10 Thread Josh Berkus
Folks, Magnus and I decided to take on the annual /contrib cleanup for the code sprint here at pgWest. One of the areas we realized needs cleanup is the use of schema with the modules -- Magnus, Bruce and I all think that contrib modules really need to create and use their own private schema.