Re: Transactions

02-01-30 10.21 Chris Thompson thompson(at)lightershade(dot)com
> I was hoping I could do it in a single transaction block? is this
> possible.
Everything between BEGIN and END is rolled back unless all actions in the
block are completed succesfully. AFAIK that is the definition of a
transaction.

Apart from that I'm not sure how to connect to a database inside a block,
let alone how to switch connections.

>If not can anyone suggest any alternatives? I also had thought
> about triggers but don't really know enough about them at present :-).

How immportant is it that both databases are sychronised? Probably you
should look into replication instead. I think there is an Open Source
project regarding replicating Postgres.

Regards,

Vänliga hälsningar

Torbjörn Andersson
---------------------------------------------------
Embryo Communication phone: +46 (0) 31-774 39 11(00)
Kungsgatan 7a fax: +46 (0)31 774 07 80
S-411 19 Göteborg mobile: 0708-30 70 04
Sweden home: http://www.embryo.se/
mail: torbjorn(dot)andersson(at)embryo(dot)se
---------------------------------------------------
"Att idag tänka annorlunda än igår skiljer den vise från den envise." — John
Steinbeck