| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-hackers pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Michel POURE | 2003-07-30 23:33:37 | Re: WebGUI vote on whether to drop PostgreSQL |
| Previous Message | Sean Chittenden | 2003-07-30 23:07:59 | Re: [PATCHES] [PATCH] Re: Why READ ONLY transactions? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Chittenden | 2003-07-30 23:42:31 | Re: [PATCHES] [PATCH] Re: Why READ ONLY transactions? |
| Previous Message | Tom Lane | 2003-07-30 23:23:26 | Any unapplied patches out there? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Chittenden | 2003-07-30 23:42:31 | Re: [PATCHES] [PATCH] Re: Why READ ONLY transactions? |
| Previous Message | Ron Johnson | 2003-07-30 23:24:59 | Re: hexadecimal to decimal |