On 8/22/07, Andrew Sullivan <ajs at crankycanuck.ca> wrote:
>
> First, please don't post HTML mail.
>
> On Wed, Aug 22, 2007 at 05:38:38PM +0530, Trinath Somanchi wrote:
> > created in master . All the archive tables are dynamically created with
> > name archive_logs_&lt;timestamp&gt; as the table name . Is there any
> > other way how to automate this process .
>
> No.  Slony doesn't support this sort of thing.  DDL is done via
> EXECUTE SCRIPT.  Future versions of Slony might make this slightly
> less painful, but I don't think dynamic DDL is on the roadmap at the
> moment.  (The "less painful" part comes from fixing the catalogue
> corruption problems.)
>

Since your application is dynamically creating and dropping tables, if you
wanted these tables to be replicated, then you'd presumably need to change
your application so that it does it's DDL via slonik's execute script (or
directly, mimicking the functionality of slonik execute script, if you're
willing to handle that level of complexity in you code) followed by
appropriate create set and subscribe commands.

I am not aware of anyone doing this. In fact, this bring's to mind Jan's
comments about schema-modifying applications and self-modifying software...

Andrew
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070822/=
093eb4cb/attachment.htm