Re: calling function from rule

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: calling function from rule
Дата
Msg-id 26610.1043341252@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: calling function from rule  ("Tambet Matiisen" <t.matiisen@aprote.ee>)
Ответы SQL to list databases?
Список pgsql-sql
"Tambet Matiisen" <t.matiisen@aprote.ee> writes:
>> Try 7.3, we changed the rules about returned records count.

> I have 7.3. When rule and action are the same, everything works fine.
> Doing an insert in update rule and opposite are OK too. Problem is,
> when I do select in insert/update/delete rule. Then the result of
> select is returned instead of command status, even if the select
> is done in non-instead rule and there is unconditional instead rule.

Oh, I think your complaint is really about the fact that psql doesn't
print the command status if it got any tuples (or even just a tuple
descriptor) in the result series.  AFAICT the information returned by
the backend is sensible in this situation: the "UPDATE 1" status message
*is* returned and is available from PQcmdStatus.  psql is just choosing
not to print it.  I'm not sure that that's wrong, though.
        regards, tom lane


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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: To use a VIEW or not to use a View.....
Следующее
От: Tom Lane
Дата:
Сообщение: Re: To use a VIEW or not to use a View.....