Re: Does psql use nested transactions?

From: Haroldo Stenger <haroldo(dot)stenger(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Does psql use nested transactions?
Date: 2004-08-17 18:33:01
Message-ID: d33fde4e040817113331badd68@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Tom

On Wed, 11 Aug 2004 11:47:35 -0400, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> The other objection is that this would create very substantial overhead.

why?

> It might be reasonable to offer that behavior as an option, but I think
> I'd only want it on for interactive input.

How could the server tell interactive input from scripted intput
without an explicit setting meant to do it? Is ther already any
conciousness on the server part about who is talking to it?

Other than performance issues, I don't see why this is more dangerous
than any other settings.

Regards
Haroldo

--
Por favor registre haroldo(dot)stenger(at)gmail(dot)com como mi nueva y unica
direccion de correo en lugar de la vieja hstenger(at)adinet(dot)com(dot)uy
Please, record haroldo(dot)stenger(at)gmail(dot)com as my new and unique email
address instead of ye old hstenger(at)adinet(dot)com(dot)uy
Gracias. Thankyou.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-08-17 18:42:53 Re: Does psql use nested transactions?
Previous Message Magnus Hagander 2004-08-17 18:28:55 Re: initdb failure on win32