Re: Update rule on a view - what am I doing wrong

Поиск
Список
Период
Сортировка
От Marc Schablewski
Тема Re: Update rule on a view - what am I doing wrong
Дата
Msg-id 50FE9AC6.6060701@clickware.de
обсуждение исходный текст
Ответ на Re: Update rule on a view - what am I doing wrong  (Leif Jensen <leif@crysberg.dk>)
Список pgsql-general
Hi Leif,
  Am 22.01.2013 14:34, schrieb Leif Jensen:
CREATE update_rule_func( old record, new record ) AS ...  I am told, that I cannot use record for the parameter type. Could you please 
You should use your view instead of 'record' as parameter type, i.e. CREATE update_rule_func( old V_YOUR_VIEW, new V_YOUR_VIEW ) AS ... . Also, I'm not sure if 'new' and 'old' are reserved keywords in PostgreSQL, so you might want to choose different names for your parameters if you still have trouble with that function.

Marc

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

Предыдущее
От: Leif Jensen
Дата:
Сообщение: Re: Update rule on a view - what am I doing wrong
Следующее
От: Dmitriy Igrishin
Дата:
Сообщение: RAISE NOTICE ... and CONTEXT field of the error report.