Re: `transaction_read_only` GUC undocumented

From: Pavlo Golub <pavlo(dot)golub(at)cybertec(dot)at>
To: Michael Paquier <michael(at)paquier(dot)xyz>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: `transaction_read_only` GUC undocumented
Date: 2019-01-23 06:56:04
Message-ID: 1663901278.20190123085604@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Greetings, Michael.

You wrote 23.01.2019, 8:14:

> On Wed, Jan 23, 2019 at 01:07:31AM -0500, Tom Lane wrote:
>> Michael Paquier <michael(at)paquier(dot)xyz> writes:
>>> transaction_read_only is listed in src/backend/utils/misc/guc.c, so we
>>> could put a description close to default_transaction_read_only in
>>> config.sgml, except that transaction_read_only sets the current
>>> transaction's read-only status.
>>
>> Do we really want to document that? It's not the standard-approved
>> way of making a transaction read-only.

> i'd rather document them clearly rather than letting them around with
> users guessing what they actually do (remember the recent thread about
> replication parameter in connection strings).

Exactly my case. Client sent support request stating that changing
this parameter doesn't work. Of course, he was doing this outside of
transaction. And of course he doesn't find manual reference and was
guessing about it's behavior.

> By the way, I can see
> that transaction_deferrable and transaction_isolation are not around
> either...

> --
> Michael

--
Kind regards,
Pavlo mailto:pavlo(dot)golub(at)cybertec(dot)at

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2019-01-23 23:53:12 Re: First SVG graphic
Previous Message Michael Paquier 2019-01-23 06:14:22 Re: `transaction_read_only` GUC undocumented