OK, now I will answer my own question. It seems that ALTER TABLE MyCoolTable_1 DISABLE TRIGGER trg_foo_1 ; is a no-op when it is currently disabled. And so no "txn id" is "needed". When I alternate DISable and ENable statements, it behaves as I expect . . . Start Transaction; DO $$ BEGIN raise info '%', txid_current(); END $$; ALTER TABLE MyCoolTable_1 DISABLE TRIGGER trg_foo_1 ; Commit; Start Transaction; ALTER TABLE MyCoolTable_1 ENABLE TRIGGER trg_foo_1 ; Commit; Start Transaction; DO $$ BEGIN raise info '%', txid_current(); END $$; ALTER TABLE MyCoolTable_1 DISABLE TRIGGER trg_foo_1 ; Commit; Start Transaction; ALTER TABLE MyCoolTable_1 ENABLE TRIGGER trg_foo_1 ; Commit; Start Transaction; DO $$ BEGIN raise info '%', txid_current(); END $$; ALTER TABLE MyCoolTable_1 DISABLE TRIGGER trg_foo_1 ; Commit; Start Transaction; ALTER TABLE MyCoolTable_1 ENABLE TRIGGER trg_foo_1 ; Commit; INFO: 7958 INFO: 7960 INFO: 7962 Thanks, -dvs- From: Pavan Deolasee [mailto:pavan.deolasee@xxxxxxxxx] On Wed, Sep 5, 2012 at 10:53 PM, Sahagian, David <david.sahagian@xxxxxxx> wrote: Why are the Messages displayed by my pgAdmin sql window like this . . . INFO: 7902 INFO: 7903 INFO: 7904 instead of what I expected . . . INFO: 7902 INFO: 7904 INFO: 7906 ??? Are you sure those ALTER TABLE commands are executing without an error ? The only way I can see you get those messages is when ALTER TABLE for tables MyCoolTable_2 and MyCoolTable_4 (and possibly others too) are failing for some reason. Thanks, Pavan |
