Artacus <artacus@xxxxxxxxxxx> 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
