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

Re: BUG #2758: missing quotes in SQL sentence

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: scoanda <sabin(dot)coanda(at)deuromedia(dot)ro>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2758: missing quotes in SQL sentence
Date: 2006-11-14 19:15:59
Message-ID: 20061114191559.GJ90133@nasby.net (view raw or flat)
Thread:
Lists: pgsql-bugs
That's a pgadmin bug; please report it to them.

On Tue, Nov 14, 2006 at 03:42:53PM +0000, scoanda wrote:
> 
> 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.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>        message can get through to the mailing list cleanly
> 

-- 
Jim Nasby                                            jim(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

In response to

pgsql-bugs by date

Next:From: Dave PageDate: 2006-11-14 19:39:27
Subject: Re: BUG #2758: missing quotes in SQL sentence
Previous:From: Leon Miller-OutDate: 2006-11-14 16:25:01
Subject: BUG #2759: \df doesn't show functions with no args

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