Re: [GENERAL] values from txid_current()

2012-09-05 Thread Sahagian, David
[mailto:pavan.deola...@gmail.com] Sent: Wednesday, September 05, 2012 1:46 PM To: Sahagian, David Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] values from txid_current() On Wed, Sep 5, 2012 at 10:53 PM, Sahagian, David mailto:david.sahag...@emc.com>> wrote: Why are the Messages

Re: [GENERAL] values from txid_current()

2012-09-05 Thread Pavan Deolasee
On Wed, Sep 5, 2012 at 10:53 PM, Sahagian, David 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 com

[GENERAL] values from txid_current()

2012-09-05 Thread Sahagian, David
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;