Re: [PATCHES] Updated instrumentation patch

2005-08-03 Thread Peter Eisentraut
Am Samstag, 30. Juli 2005 16:39 schrieb Magnus Hagander: > * Added guc option "disable_remote_admin", that disables any write > operations (write, unlink, rename) even for the superuser. I think it would be better to avoid "double negatives", so the option might be better named "enable_remote_adm

Re: [PATCHES] per user/database connections limit again

2005-08-03 Thread Peter Eisentraut
Am Montag, 1. August 2005 16:08 schrieb Bruce Momjian: > > Would this not work in the context of the general user-specific ALTER > > USER ... SET something = something? > > No because it isn't a GUC variable, it is per-user/db value. GUC supports per-user/per-db values. -- Peter Eisentraut http:

Re: [PATCHES] per user/database connections limit again

2005-08-03 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Am Montag, 1. August 2005 16:08 schrieb Bruce Momjian: >>> Would this not work in the context of the general user-specific ALTER >>> USER ... SET something = something? >> >> No because it isn't a GUC variable, it is per-user/db value. > GUC supports

Re: [PATCHES] per user/database connections limit again

2005-08-03 Thread Petr Jelinek
Peter Eisentraut wrote: GUC supports per-user/per-db values. We already had discussion here about GUC for this and we agreed that catalog change is better than new GUC variable in this case. -- Regards Petr Jelinek (PJMODOS) ---(end of broadcast)--

[PATCHES] PL/pgSQL: EXCEPTION NOSAVEPOINT

2005-08-03 Thread Matt Miller
This was motivated by the SELECT INTO EXACT discussion at http://archives.postgresql.org/pgsql-patches/2005-07/msg00559.php. The idea is to allow a PL/pgSQL exception to not automatically rollback the work done by the current block. The benefit is that exception handling can be used as a program

Re: [PATCHES] PL/pgSQL: EXCEPTION NOSAVEPOINT

2005-08-03 Thread Tom Lane
Matt Miller <[EMAIL PROTECTED]> writes: > The idea is to allow a PL/pgSQL exception to not automatically rollback > the work done by the current block. This fundamentally breaks the entire backend. You do not have the option to continue processing after elog(ERROR); the (sub)transaction rollback

Re: [PATCHES] PL/pgSQL: EXCEPTION NOSAVEPOINT

2005-08-03 Thread Matt Miller
On Wed, 2005-08-03 at 16:25 -0400, Tom Lane wrote: > > The idea is to allow a PL/pgSQL exception to not automatically > > rollback the work done by the current block. > > This fundamentally breaks the entire backend. Yeah, but besides that, can you quick commit this to HEAD so I don't have to kee

Re: [PATCHES] PL/pgSQL: EXCEPTION NOSAVEPOINT

2005-08-03 Thread Tom Lane
Matt Miller <[EMAIL PROTECTED]> writes: > On Wed, 2005-08-03 at 16:25 -0400, Tom Lane wrote: >> You do not have the >> option to continue processing after elog(ERROR); the (sub)transaction >> rollback is necessary to clean up inconsistent state. > Okay, I'll look at this more closely. Can you giv