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?!

Thanks heaps,
Chris

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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

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 <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?!
>
> Thanks heaps,
> Chris
>
> __________________________________________________ ___________________
> Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
> http://smartsurfer.web.de/?mc=100071...d=000000000066
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

-----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+le9gH 3ETX051ACcC25X
Y5N2tk9XweRCKSwVVMQFP1Q=
=zG8a
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

> 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/s...l-trigger.html

Bye,
Chris.



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster