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

BUG #6152: possibly wrong display of pg_settings.enumvals for default_transaction_isolation

From: "Christoph Anton Mitterer" <calestyo(at)scientia(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6152: possibly wrong display of pg_settings.enumvals for default_transaction_isolation
Date: 2011-08-05 20:54:42
Message-ID: 201108052054.p75Ksg82047058@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      6152
Logged by:          Christoph Anton Mitterer
Email address:      calestyo(at)scientia(dot)net
PostgreSQL version: 9.0
Operating system:   Debian sid
Description:        possibly wrong display of pg_settings.enumvals for
default_transaction_isolation
Details: 

Hi

$ psql -c 'SELECT name,vartype,enumvals FROM pg_settings;' | grep
default_transaction_isolation
could not change directory to "/root"
 default_transaction_isolation   | enum    | {serializable,"repeatable
read","read committed","read uncommitted"}

Using e.g.:
default_transaction_isolation = "read committed"
does not work however. It only works in single quotes.

If I don't get something wrong, there should be either a bug in the output
of pg_settings.enumvals or the parsing of the config file.


Cheers,
Chris.

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-08-05 21:21:28
Subject: Re: BUG #6152: possibly wrong display of pg_settings.enumvals for default_transaction_isolation
Previous:From: Tom LaneDate: 2011-08-05 05:36:53
Subject: Re: BUG #6151: documentation claims that default value for log_timezone is "unknown"

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