Hi all,
Ive been studying the whole evening and dont seem to find an answer:
I want to store transactions on the server- like views, or, (sorry) as in M$ SQL Server CREATE R REPLACE TRANSACTIN 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 zu sparen!
(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

10/3/06, kaspro (AT) web (DOT) de <kaspro (AT) web (DOT) dewrote:

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 R REPLACE TRANSACTIN 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 zu sparen!

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

PGP SIGNED MESSAGE
Hash: SHA1

In this context, what is a "transaction"?

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

10/3/06, *kaspro (AT) web (DOT) de <mailto:kaspro (AT) web (DOT) de>* <kaspro (AT) web (DOT) de
<mailto:kaspro (AT) web (DOT) 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 R REPLACE TRANSACTIN 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.
PGP SIGNATURE
Version: GnuPG v1.4.5 (GNU/Linux)

Y5N2tk9XweRCKSwVVMQFP1Q=
=zG8a
PGP SIGNATURE

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

Ive been studying the whole evening and t seem to find an answer:
I want to transactions on the server- like s, or, (sorry) as in M$ SQL Server CREATE R REPLACE TRANSACTIN xyz()

course, it's possible.
What you need is
CREATE R REPLACE FUNCTIN xyz() RETURNS trigger AS
then
CREATE TRIGGER EXECUTE PRCEDURE xyz();

Look here for an example:

Bye,
Chris.

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