Re: storing transactions - Mailing list pgsql-general

From Chris Mair
Subject Re: storing transactions
Date
Msg-id 1160066592.2501.47.camel@ultra.home.lan
Whole thread Raw
In response to storing transactions  (kaspro@web.de)
List 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
TRANSACTIONxyz()........  

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 by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: PostgreSQL Database Transfer between machines(again)
Next
From: Rajarshi Guha
Date:
Subject: indexing for query speed - index row size exceeding btree maximum