Re: storing transactions

From: Chris Mair <chrisnospam(at)1006(dot)org>
To: kaspro(at)web(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: storing transactions
Date: 2006-10-05 16:43:11
Message-ID: 1160066592.2501.47.camel@ultra.home.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rajarshi Guha 2006-10-05 16:52:08 indexing for query speed - index row size exceeding btree maximum
Previous Message Andreas Kretschmer 2006-10-05 15:52:59 Re: PostgreSQL Database Transfer between machines(again)