Re: [HACKERS] Transactions through dblink_exec()

2002-10-13 Thread Masaru Sugawara
On Sat, 12 Oct 2002 23:37:18 -0700 Joe Conway <[EMAIL PROTECTED]> wrote: > Masaru Sugawara wrote: > > I'm hoping that dblink_exec() returns something like warning if those > > who intend to do transactions make a declaration of > > blink_exec('dbname=some', 'begin') by mistake. > > > > for exampl

Re: [HACKERS] Transactions through dblink_exec()

2002-10-12 Thread Mike Mascari
Masaru Sugawara wrote: Hi, all While trying dblink_exec(), one of dblink()'s functions, I noticed there was an odd situation: case 1 and case 2 worked well, but case 3 didn't(see below). I hadn't been aware of it so that I only executed BEGIN and END in dblink_exec() at first . This time, howev

Re: [HACKERS] Transactions through dblink_exec()

2002-10-12 Thread Joe Conway
Mike Mascari wrote: How can dblink() possibly be used safely for non-readonly transactions without a full implementation of a two-phase commit protocol? What happens when the remote server issues the COMMIT and then the local server crashes? It can't be used safely if you're trying to ensure

Re: [HACKERS] Transactions through dblink_exec()

2002-10-12 Thread Joe Conway
Masaru Sugawara wrote: I'm hoping that dblink_exec() returns something like warning if those who intend to do transactions make a declaration of blink_exec('dbname=some', 'begin') by mistake. for example WARNING :You should declare dblink_exec('dbname=some', 'BEGIN; some queries; COMMIT/ROLLBA

[HACKERS] Transactions through dblink_exec()

2002-10-12 Thread Masaru Sugawara
Hi, all While trying dblink_exec(), one of dblink()'s functions, I noticed there was an odd situation: case 1 and case 2 worked well, but case 3 didn't(see below). I hadn't been aware of it so that I only executed BEGIN and END in dblink_exec() at first . This time, however, I noticed it by exec