Re: [PATCH] Re: [pgsql-advocacy] Why READ ONLY transactions?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Sean Chittenden <sean(at)chittenden(dot)org>, pgsql-patches(at)postgresql(dot)org
Subject: Re: [PATCH] Re: [pgsql-advocacy] Why READ ONLY transactions?
Date: 2003-12-01 19:12:46
Message-ID: 200312011912.hB1JCkM27624@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers pgsql-patches

Josh Berkus wrote:
> Bruce,
>
> > This seems like a valuable feature, as others have mentioned. However,
> > should it also prevent changes to default_transaction_read_only?
> >
> > What is the use case for this functionality?
>
> I thought that this was rejected thouroughly by Tom some months ago. He
> argued pretty strongly that READ ONLY transactions were *not* a security
> feature and that trying to make them one would work very poorly.

I remember something like that, but I thought the patch was the result
of that discussion. Tom?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Martin_Hurst 2003-12-01 19:29:16 Where is Postgesql ? - MYSQL SURPRISES WITH MAXDB / MySQL appliance for Linux arrives
Previous Message Josh Berkus 2003-12-01 19:10:07 Re: advocacy.postgresql.org russian translation

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-12-01 19:57:05 Re: [PATCH] Re: [pgsql-advocacy] Why READ ONLY transactions?
Previous Message Josh Berkus 2003-12-01 18:59:50 Re: [PATCH] Re: [pgsql-advocacy] Why READ ONLY transactions?

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2003-12-01 19:57:05 Re: [PATCH] Re: [pgsql-advocacy] Why READ ONLY transactions?
Previous Message Bruce Momjian 2003-12-01 19:10:14 Re: export FUNC_MAX_ARGS as a read-only GUC variable