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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general