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! _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
