values from txid_current() - Mailing list pgsql-general

From Sahagian, David
Subject values from txid_current()
Date
Msg-id F3CBFBA88397EA498B22A05FFA9EC49DA833943E@MX22A.corp.emc.com
Whole thread Raw
Responses Re: values from txid_current()
List 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-
 
 

pgsql-general by date:

Previous
From: jam3
Date:
Subject: Re: Where is the char and varchar length in pg_catalog for function input variables
Next
From: Pavan Deolasee
Date:
Subject: Re: values from txid_current()