Re: insert/update/delete statements returning a query response

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB SD
Тема Re: insert/update/delete statements returning a query response
Дата
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA41EB435@m0114.s-mxs.net
обсуждение исходный текст
Ответ на insert/update/delete statements returning a query response  (Barry Lind <barry@xythos.com>)
Список pgsql-hackers
> Is this behavior intended in the backend?  The problem is that when
you 
> create a rule on an object that calls a stored function and invoke
that 
> rule on an insert/update/delete statement your insert/update/delete 
> statement will now return a query result to the front end over the
FE/BE 
> protocol.

Since this behavior is essential to the rule system, imho the actual
source
of problems is, that PostgreSQL does not have "real stored procedures"
==
functions that do not have a return value or set (C lingo: void
func_a(x)).

The usual view rule that needs enhanced processing intelligence would
then call a stored procedure and not a function.

The easy way out would be to write rules with instead actions, that
call insert/update/delete statemants directly. This often works
for the more common cases.

Andreas


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Pre-page images in WAL
Следующее
От: "Zeugswetter Andreas SB SD"
Дата:
Сообщение: Re: Pre-page images in WAL