On Fri, 2006-04-07 at 08:33, Marcin Ma?k wrote:
> Hello.
> The general policy for slony is 'no ddl should be performed on replicated
> databases'. Does this apply to temporary tables too? Can I safely create
> temporary tables on the master/on the slaves ?

Slony doesn't replicate databases.  It replicates data sets on
databases.  So, as long as what you're mucking about with isn't in the
replication set, you're cool.

Note that since indexes live outside of tables, it's quite possible to
have a source set with the bare needed indexes for data coherency, and a
subscriber with extra indexes on things like functions and such (careful
with unique indexes, you can make a subscriber than can't update) that
allow for fast reporting.  

So, temp tables are your to play with, unless you're actually somehow
replicating them.  Which would require more than a little effort and a
fair bit of the crazy.  :)