Access to inserted rows via select in a statement

Поиск

Список

Период

Сортировка

От	Jake Stride
Тема	Access to inserted rows via select in a statement
Дата	19 октября 2011 г. 20:25:54
Msg-id	C93A5FF78A194B07A3FCBA46A600DC4E@stride.me.uk обсуждение исходный текст
Ответы	Re: Access to inserted rows via select in a statement
Список	pgsql-general

Дерево обсуждения

I am writing a function that is called by a trigger after insert and update but it is not returning all the rows I want it to with a SELECT.

This trigger is called within a transaction and looks for a row inserted previously within the same transaction - it works when the trigger is called via UPDATE as the row exists from a previous insert but not the first time it is called.

Should a SELECT function within a function and a transaction be able to select other rows that have just been inserted in the transaction, but before it is committed?

Thanks

Jake

--
Jake Stride

Find out more http://about.me/jakestride or follow me on twitter @jake.

В списке pgsql-general по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Access to inserted rows via select in a statement