Re: Getting rows in statement-level triggers

From: Artacus <artacus(at)comcast(dot)net>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Getting rows in statement-level triggers
Date: 2008-10-03 06:12:05
Message-ID: 48E5B7B5.2070903@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Asko Oja 2008-10-03 06:30:46 Re: [HACKERS] Transactions within a function body
Previous Message Klint Gore 2008-10-03 05:04:38 Re: How do I save data and then raise an exception?