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

BUG #2758: missing quotes in SQL sentence

From: "scoanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2758: missing quotes in SQL sentence
Date: 2006-11-14 15:42:53
Message-ID: 200611141542.kAEFgrCp061138@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2758
Logged by:          scoanda
Email address:      sabin(dot)coanda(at)deuromedia(dot)ro
PostgreSQL version: 8.1.4
Operating system:   Windows XP sp2
Description:        missing quotes in SQL sentence
Details: 

I set the transaction isolation level for an user with 
ALTER ROLE <user> SET default_transaction_isolation='read committed';

In pgAdmin I get the sentence without quotes:
ALTER ROLE <user> SET default_transaction_isolation=read committed;

This doesn't work if I copy/paste to SQL Query window.

Responses

pgsql-bugs by date

Next:From: Leon Miller-OutDate: 2006-11-14 16:25:01
Subject: BUG #2759: \df doesn't show functions with no args
Previous:From: Andreas LangeDate: 2006-11-14 13:41:04
Subject: Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio

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