Sat Mar 21 03:58:23 PDT 2009
- Previous message: [Slony1-general] Slony-I Replication
- Next message: [Slony1-general] Slony is ACID relative to data changes, but not ACID relative to DDL changes
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hello. Possibly this fact needs to be included in the documentation? Steps to reproduce: 1. Create table with name "b" on slave manually (emulate an error of broken replication, see below). 2. Check that there is no table "b" on master. 3. Run via slonik's EXECUTE DDL within TRY block (in the single transaction): CREATE TABLE a(id INTEGER); CREATE TABLE b(id INTEGER); 4. On master, this query successfully finishes. On slave, only table "a" is created (and committed!), but "b" is not (it already exists). 5. Conclustion: on master, "a" and "b" are created within the single transaction. On slave, "a" and "b" are created within different transactions. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090321/= 14e9690b/attachment.htm
- Previous message: [Slony1-general] Slony-I Replication
- Next message: [Slony1-general] Slony is ACID relative to data changes, but not ACID relative to DDL changes
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list