Re: storing transactions

Поиск
Список
Период
Сортировка
Искать
От
Chris Mair
Тема
Re: storing transactions
Дата
Msg-id
1160066592.2501.47.camel@ultra.home.lan
Ответ на
storing transactions (kaspro@web.de)
Список
Дерево обсуждения
Re: storing transactions kaspro@web.de

> I’ve been studying the whole evening and don’t seem to find an answer:
> I want to “store” transactions on the server- like view’s, or, (sorry) as in M$ SQL Server CREATE OR REPLACE TRANSACTION xyz()........ 

Of course, it's possible.
What you need is
CREATE OR REPLACE FUNCTION xyz() RETURNS trigger AS ...
then
CREATE TRIGGER ... EXECUTE PROCEDURE xyz();


Look here for an example:
http://www.postgresql.org/docs/8.1/static/plpgsql-trigger.html

Bye,
Chris.


В списке pgsql-general по дате отправления
От: Andreas Kretschmer
Дата:
От: Rajarshi Guha
Дата:
FAQ