Chris Browne wrote:
> [EMAIL PROTECTED] ("Jim C. Nasby") writes:
>
> > On Tue, Nov 01, 2005 at 11:23:55AM -0300, Alvaro Herrera wrote:
> >> Tom Lane wrote:
> >> > "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> >> > > AFAIK they're not using subtransactions at all, but I'll check.
> >> >
> >> > Well, yeah, they are ... else you'd never have seen this failure.
> >>
> >> Maybe it's in plpgsql EXCEPTION clauses.
> >
> > Err, I forgot they're using Slony, which is probably using savepoints
> > and/or exceptions.
>
> Slony-I does use exceptions in pretty conventional ways; it does *not*
> make any use of subtransactions, because it needs to run on PG 7.3 and
> 7.4 that do not support subtransactions.
Hmm, does it use the BEGIN/EXCEPTION/END construct at all? Because if
it does, it won't work on 7.4; and if it doesn't, then it isn't using
savepoints in 8.0 either.
--
Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"Siempre hay que alimentar a los dioses, aunque la tierra esté seca" (Orual)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
