Обсуждение: storing transactions

Hi all,
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()........  
Is this possible with postgres or do I have to store all these at the client side?!

Thanks heaps,
Chris

_____________________________________________________________________
Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
http://smartsurfer.web.de/?mc=100071&distributionid=000000000066

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In this context, what is a "transaction"?

On 10/04/06 14:32, Talha Khan wrote:
> You can save your transactions in an sql file and then run that file
> whenever you need to run those transactions.
>
> Regards
> Talha Khan
>
>
> On 10/3/06, *kaspro@web.de <mailto:kaspro@web.de>* <kaspro@web.de
> <mailto:kaspro@web.de>> wrote:
>
>     Hi all,
>     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()........
>     Is this possible with postgres or do I have to store all these at
>     the client side?!

- --
Ron Johnson, Jr.
Jefferson LA  USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFFJA+SS9HxQb37XmcRAgRHAKDf0wqR78o2ImFV+le9gH3ETX051ACcC25X
Y5N2tk9XweRCKSwVVMQFP1Q=
=zG8a
-----END PGP SIGNATURE-----

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

Mabye I made myself not clear enough- sorry for that...
What I want is having a statement like:

PROCEDURE MyProcedure(Value1 int, Value2 text, Value3 varchar(30))
BEGIN
   ---check if something is valid
   ---compute something
   ---store values I got via THIS query and put them in table A, B and C
   ---see wether everything is ok
COMMIT;

...which I execute from a client like: exec MyProcedure(Value1, Value2, Value3)

Sorry for beeing not exact enough...

Thanks in advance,
Chris

> -----Ursprüngliche Nachricht-----
> Von: Chris Mair <chrisnospam@1006.org>
> Gesendet: 05.10.06 18:43:23
> An: kaspro@web.de
> CC: pgsql-general@postgresql.org
> Betreff: Re: [GENERAL] storing transactions


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


_____________________________________________________________________
Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
http://smartsurfer.web.de/?mc=100071&distributionid=000000000066