Skip site navigation (1) Skip section navigation (2)

Re: Connection Pools and DISCARD ALL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Neil Conway <neilc(at)samurai(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Connection Pools and DISCARD ALL
Date: 2007-10-04 21:08:29
Message-ID: 21198.1191532109@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> Could we maybe have some flavor of ROLLBACK that doesn't issue a warning 
> if no transaction is in progress? There is precedent for this sort of 
> facility - DROP ... IF EXISTS.

Something that would actually be doable for 8.3 would be to downgrade
this particular WARNING to a NOTICE.  A DBA who hasn't got
log_min_messages set higher than NOTICE hasn't really got a lot of room
to whine about bulky logs.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2007-10-04 21:33:42
Subject: Re: First steps with 8.3 and autovacuum launcher
Previous:From: Andrew DunstanDate: 2007-10-04 21:03:36
Subject: ecpg build now breaks mingw

pgsql-patches by date

Next:From: Euler Taveira de OliveiraDate: 2007-10-07 22:47:06
Subject: pt_BR FAQ update
Previous:From: Andrew DunstanDate: 2007-10-04 20:27:06
Subject: Re: Connection Pools and DISCARD ALL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group