Re: values from txid_current()

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(dot)deolasee(at)gmail(dot)com]
Sent: Wednesday, September 05, 2012 1:46 PM
To: Sahagian, David
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] values from txid_current()

On Wed, Sep 5, 2012 at 10:53 PM, Sahagian, David <david(dot)sahagian(at)emc(dot)com<mailto:david(dot)sahagian(at)emc(dot)com>> 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