Skip site navigation (1) Skip section navigation (2)

Re: [PATCH] Magic block for modules

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Kings-Lynne <chris(dot)kings-lynne(at)calorieking(dot)com>
Cc: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-patches(at)postgresql(dot)org, Martijn van Oosterhout <kleptog(at)svana(dot)org>, Marko Kreen <markokr(at)gmail(dot)com>
Subject: Re: [PATCH] Magic block for modules
Date: 2006-06-02 02:49:30
Message-ID: 23504.1149216570@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Christopher Kings-Lynne <chris(dot)kings-lynne(at)calorieking(dot)com> writes:
>> I really think this is backwards: you should be looking for the .sql
>> files.  Every module will have a .sql file, not every one will need a
>> .so file.  See followup thread in -hackers where we're trying to hash
>> out design details.

> Not in this case.

> Basically Slony has the concept of installing a node into a server.  You 
> can have multiple ones of them - different schemas.  So, I'd like to be 
> able to detect that the .so is there, and then offer an "install node" 
> feature where WE execute the SQL on their behalf, with all the 
> complicated string substitions already done.

No, Slony is going to have to adapt to modules, not vice versa.  We are
*not* designing the module feature on the assumption that every module
has some C functions at its core.  That would be a shameful restriction
of the potential applications.

It might be that some way to parameterize the SQL scripts would be handy
(the question about which schema to install into comes to mind) ... but
that doesn't justify making a .so file the central part of the module
concept.

But again, this is the wrong list.  Please contribute to the
"Generalized concept of modules" thread in -hackers.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Robert TreatDate: 2006-06-02 02:55:03
Subject: Re: [PATCH] Magic block for modules
Previous:From: Christopher Kings-LynneDate: 2006-06-02 02:39:20
Subject: Re: [PATCH] Magic block for modules

pgsql-patches by date

Next:From: Robert TreatDate: 2006-06-02 02:55:03
Subject: Re: [PATCH] Magic block for modules
Previous:From: Christopher Kings-LynneDate: 2006-06-02 02:39:20
Subject: Re: [PATCH] Magic block for modules

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group