Artacus <artacus(at)comcast(dot)net> writes:
> 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
This will not work, or at least it will stop working after your
installation passes 4 billion transactions.
The traditional way to find out your own XID is to insert a dummy row
somewhere (perhaps in a temp table) and see what its xmin is. I'm not
sure why we don't expose a more convenient way --- maybe just that
there's not been any demand for it.
regards, tom lane