values from txid_current()

From: "Sahagian, David" <david(dot)sahagian(at)emc(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: values from txid_current()
Date: 2012-09-05 17:23:24
Message-ID: F3CBFBA88397EA498B22A05FFA9EC49DA833943E@MX22A.corp.emc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Using 9.1.3

Start Transaction; DO $$ BEGIN raise info '%', txid_current(); END $$; ALTER TABLE MyCoolTable_1 DISABLE TRIGGER trg_foo_1 ; Commit;
Start Transaction; ALTER TABLE MyCoolTable_2 DISABLE TRIGGER trg_foo_2 ; Commit;
Start Transaction; DO $$ BEGIN raise info '%', txid_current(); END $$; ALTER TABLE MyCoolTable_3 DISABLE TRIGGER trg_foo_3 ; Commit;
Start Transaction; ALTER TABLE MyCoolTable_4 DISABLE TRIGGER trg_foo_4 ; Commit;
Start Transaction; DO $$ BEGIN raise info '%', txid_current(); END $$; ALTER TABLE MyCoolTable_5 DISABLE TRIGGER trg_foo_5 ; Commit;

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
???

Thanks,
-dvs-

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavan Deolasee 2012-09-05 17:46:03 Re: values from txid_current()
Previous Message Tom Lane 2012-09-05 17:03:16 Re: postgres process got stuck in "notify interrupt waiting" status