Vick Khera vivek at khera.org
Thu Jan 15 11:24:11 PST 2009
if i run execute script() with the "execute only on" option to limit
it to one node, does slony only take locks on that node, or does it
lock all tables on all nodes?  i'm using it to run some table
compaction.  alternatively is it safe to run a query like this outside
of execute script: "alter table user_event_log alter column user_id
type integer;" where the user_id is already an integer (and is the
PK).  this is the trick i use to compact the table and indexes after a
large data purge.

I'm running Pg 8.3 and slonly 1.2.14 on freebsd 7.0

thanks!


More information about the Slony1-general mailing list