Re: PLPGSQL and FOUND stange behaviour after EXECUTE

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: PLPGSQL and FOUND stange behaviour after EXECUTE
Дата
Msg-id 4160F96F.3060809@samurai.com
обсуждение исходный текст
Ответ на Re: PLPGSQL and FOUND stange behaviour after EXECUTE  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: PLPGSQL and FOUND stange behaviour after EXECUTE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Tom Lane wrote:
> Yeah, this has been on my to-do list for awhile...

Ah, ok. Is this something you want to handle, or should I take a look?

> One question here is whether Oracle's PL/SQL has a
> precedent, and if so which way does it point?

I did some limited testing of this, and it appears that PL/SQL's EXECUTE
IMMEDIATE modifies SQL%FOUND.

-Neil

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

Предыдущее
От: Sean Chittenden
Дата:
Сообщение: bgwriter interfering with consistent view of system tables?
Следующее
От: Sean Chittenden
Дата:
Сообщение: Denial of service via VACUUM, all backends exit and restart...