Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Owen Hartnett wrote: > >> I've been able to turn on statement logging (I've set log_statement to > >> 'all'), but it doesn't seem to show the begin transaction - commit - > >> rollback statements. Is there another way to have them show up in the log? > > > If they don't show up, they are not being executed at all; which > > explains why your transactions "don't roll back", because there are no > > transaction blocks defined at all. > > In PG 8.2 I'd agree, but older versions are not so good about logging > execution of prepared statements. What's the server version exactly, > and is there any indication of use of prepared statements in the log?
Humm, but can you prepare BEGIN or COMMIT at all? -- Alvaro Herrera http://www.advogato.org/person/alvherre "¿Cómo puedes confiar en algo que pagas y que no ves, y no confiar en algo que te dan y te lo muestran?" (Germán Poo) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
