From: | uanacho <uanacho(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | rollback doubt and connection to remoteDB |
Date: | 2011-08-25 15:35:33 |
Message-ID: | CAPbGv0y+Am9FMz3VO=DdCo5Ni+xALHfJh8A-1KM72JTBR0dRNg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi, some days ago I have a problem I want to solve.
The situation is the following:
I have a connection to a remote DB (with it's different from mine, of
course).
The querys I do are between sql-transactions
1 - Whate happens If during executing a query my pc loose the network
connection? what happens with the rollback?
Due to this time my pc that begun the query doesn't have the possibility to
invoke the rollback to the remote DB and cannot "clean" that DB
2 - Does exists any mechanism to do on the remote DB, or even a timeout that
if that timeout elapsed without any query from my pc, invoke any trigger o
event to "clean" the remote DB?
Thanks for your answers and if my question isn't clear, let me know
P.S: the postgres version I use is 8.2.3
From | Date | Subject | |
---|---|---|---|
Next Message | Massa, Harald Armin | 2011-08-25 16:21:21 | access to lexems or access to parsed elements |
Previous Message | Tom Lane | 2011-08-25 14:14:05 | Re: Sort Method: external merge |