So the manual says there is no way for a statement-level trigger to examine the row(s) modified by the statement. Is there any way to get the xmin or cmin of the transaction that fired the trigger? Or can I look up the last xid for a table some where? Ok, so it took a lot of googling to figure this one out, but you can do it with something like so. SELECT * FROM strand_scores WHERE xmin::text = txid_current()::text It appears you can't convert a xid type to int or bigint, not sure why. I guess I should leave a comment on the manual page.
So the manual says there is no way for a statement-level trigger to examine the row(s) modified by the statement. Is there any way to get the xmin or cmin of the transaction that fired the trigger? Or can I look up the last xid for a table some where?
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных