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

Re: [PATCHES] [PATCH] Re: Why READ ONLY transactions?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sean Chittenden <sean(at)chittenden(dot)org>
Cc: Christopher Browne <cbbrowne(at)libertyrms(dot)info>,pgsql-patches(at)postgresql(dot)org,Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>,Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, pgsql-advocacy(at)postgresql(dot)org
Subject: Re: [PATCHES] [PATCH] Re: Why READ ONLY transactions?
Date: 2003-07-30 23:29:37
Message-ID: 25791.1059607777@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-patches
Sean Chittenden <sean(at)chittenden(dot)org> writes:
>> I'm not objecting to the idea of being able to make users read-only.
>> I'm objecting to using GUC for it.  Send in a patch that, say, adds
>> a bool column to pg_shadow, and I'll be happy.

> How is that any different than ALTER USER [username] SET
> jail_read_only_transactions TO true?  It sets something in
> pg_shadow.useconfig column, which is permanent.

But it has to go through a mechanism that is designed and built to allow
that value to be overridden from other places.  I think using GUC for
this is just asking for trouble.  Even if there is no security hole
today, it's very easy to imagine future changes in GUC that would
unintentionally create one.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Sean ChittendenDate: 2003-07-30 23:42:31
Subject: Re: [PATCHES] [PATCH] Re: Why READ ONLY transactions?
Previous:From: Tom LaneDate: 2003-07-30 23:23:26
Subject: Any unapplied patches out there?

pgsql-patches by date

Next:From: Sean ChittendenDate: 2003-07-30 23:42:31
Subject: Re: [PATCHES] [PATCH] Re: Why READ ONLY transactions?
Previous:From: Ron JohnsonDate: 2003-07-30 23:24:59
Subject: Re: hexadecimal to decimal

pgsql-advocacy by date

Next:From: Jean-Michel POUREDate: 2003-07-30 23:33:37
Subject: Re: WebGUI vote on whether to drop PostgreSQL
Previous:From: Sean ChittendenDate: 2003-07-30 23:07:59
Subject: Re: [PATCHES] [PATCH] Re: Why READ ONLY transactions?

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