On 11/5/2004 6:19 AM, Andrew Sullivan wrote:
> On Fri, Nov 05, 2004 at 11:19:24AM +0100, "Dr. St?phane Schildknecht" wrote:
>> Hi all,
>> 
>> We have a soft that creates table whenever a new user connects to it. Is 
>> it possible to automate the creation of the tables on the slaves ?
> 
> Sort of, but if the idea is _regularly_ to do this sort of table
> creation, you're going to find Slony hard to use.  If you're really
> wedded to such a design (and I have to say that I think it's probably
> poor practice), you maybe want to check out the Command Prompt
> system, instead, since it's based on shipping logs.
> 
> Anyway, check out the DDL support in slonik. But you _must_ submit
> such changes that way for the system to work in the ways you expect.

And you will suffer from the fact that Slony grabs an exclusive table 
lock on all tables in the replication set while processing those DDL 
scripts, so it is going to be a rather disruptive process.

I consider the DB schema part of the application code and as such, 
applications that modify the schema as part of their normal daily 
operation "self modifying code" - a concept I personally have abandoned 
somewhere in the 80's.


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #