Strange trigger behaviour

Поиск
Список
Период
Сортировка
От P.V. Subramanian
Тема Strange trigger behaviour
Дата
Msg-id F133nDuFIQaj9iWiIkT0000353c@hotmail.com
обсуждение исходный текст
Список pgsql-novice
Hi

I have a trigger function (C shared library) thats supposed to get called
AFTER an INSERT.

The called function needs to read the record that was just added (which
resulted in the function call)

However, this function doesn't seem to see the latest record added. Its as
if the INSERT never completed, during the life of the function.

Of course, a SELECT * shows that the record did get added.

And the function sees all the other older records in the table.

What should I do?

(And, why dont my elog notices not show up on the screen? That would have
helped me debug a bit)

Thanks in advance

PVS



_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


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

Предыдущее
От: Matthew Braithwaite
Дата:
Сообщение: Index not used for simple query, and yes I ran vacuum analyze
Следующее
От: "Mark Tessier and Martine Veilleux"
Дата:
Сообщение: installing postgres on virtual domain