Re: Getting rows in statement-level triggers
| От | Artacus |
|---|---|
| Тема | Re: Getting rows in statement-level triggers |
| Дата | |
| Msg-id | 48E5B7B5.2070903@comcast.net обсуждение исходный текст |
| Ответ на | Getting rows in statement-level triggers (Artacus <artacus@comcast.net>) |
| Ответы |
Re: Getting rows in statement-level triggers
Re: Getting rows in statement-level triggers |
| Список | 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.
В списке pgsql-general по дате отправления: