values from txid_current()
От | Sahagian, David |
---|---|
Тема | values from txid_current() |
Дата | |
Msg-id | F3CBFBA88397EA498B22A05FFA9EC49DA833943E@MX22A.corp.emc.com обсуждение исходный текст |
Ответы |
Re: values from txid_current()
|
Список | 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 по дате отправления: