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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Sean Chittenden <sean(at)chittenden(dot)org>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCHES] [PATCH] Re: [pgsql-advocacy] Why READ ONLY transactions?
Date: 2003-07-31 09:02:01
Message-ID: Pine.LNX.4.56.0307311024460.1729@krusty.credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers pgsql-patches

Bruce Momjian writes:

> If we change default_transaction_read_only to PGC_USERLIMIT, the
> administrator can turn it on and off, but an ordinary user can only turn
> it on, but not off.
> Would that help?

No, it would break the SQL standard.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Rory Campbell-Lange 2003-07-31 11:56:51 Re: [GENERAL] interesting PHP/MySQL thread
Previous Message Peter Eisentraut 2003-07-31 09:01:57 Re: [PATCHES] [PATCH] Re: [pgsql-advocacy] Why READ ONLY transactions?

Browse pgsql-hackers by date

  From Date Subject
Next Message Manfred Koizar 2003-07-31 10:38:23 Re: Proof-of-concept for initdb-time shared_buffers selection
Previous Message Peter Eisentraut 2003-07-31 09:01:57 Re: [PATCHES] [PATCH] Re: [pgsql-advocacy] Why READ ONLY transactions?

Browse pgsql-patches by date

  From Date Subject
Next Message Andreas Pflug 2003-07-31 09:36:09 Re: ruleutils with pretty-print option
Previous Message Peter Eisentraut 2003-07-31 09:01:57 Re: [PATCHES] [PATCH] Re: [pgsql-advocacy] Why READ ONLY transactions?