Hey guys

Are there any good examples of doing this kind of thing using the stored
procedures?  I googled before and couldn't find anything

Mark


-----Original Message-----
From: Andrew Sullivan [mailto:ajs at crankycanuck.ca] 
Sent: Wednesday, June 14, 2006 14:25
To: Mark Adan
Cc: Andrew Sullivan; slony1-general at gborg.postgresql.org
Subject: Re: [Slony1-general] Good examples of calling slony
storedprocedures

On Wed, Jun 14, 2006 at 01:27:54PM -0700, Mark Adan wrote:
> Hi
> 
> Again, I'm new at this.  I think I'm ok as long as slony knows about
the
> new table before any rows are added in the master database

No.  There are race conditions there.  See previous discussions about
exactly this using _slonik_ in the archives.  The functions will be
even worse.  You need a wait for event.

In general, Slony is designed not to support -- I'm inclined to say,
"to foil" -- attempts of applications to perform DDL as part of
standard operations.

A


-- 
Andrew Sullivan  | ajs at crankycanuck.ca
The fact that technology doesn't work is no bar to success in the
marketplace.
		--Philip Greenspun