Re: BUG #2758: missing quotes in SQL sentence - Mailing list pgsql-bugs

From Dave Page
Subject Re: BUG #2758: missing quotes in SQL sentence
Date
Msg-id 200611141939270000@263183057
Whole thread Raw
In response to BUG #2758: missing quotes in SQL sentence  ("scoanda" <sabin.coanda@deuromedia.ro>)
Responses Re: BUG #2758: missing quotes in SQL sentence
List pgsql-bugs
No, it's the intended behaviour. pgAdmin doesn't have any idea how you want to quote SET values, so it leaves it to you
toadd them. 

Regards, Dave

> ------- Original Message -------
> From: "Jim C. Nasby" <jim@nasby.net>
> To: scoanda <sabin.coanda@deuromedia.ro>
> Sent: 14/11/06, 19:15:59
> Subject: Re: [BUGS] BUG #2758: missing quotes in SQL sentence
>
> 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.coanda@deuromedia.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@postgresql.org so that your
> >        message can get through to the mailing list cleanly
> >
>
> --
> Jim Nasby                                            jim@nasby.net
> EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

pgsql-bugs by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: BUG #2758: missing quotes in SQL sentence
Next
From: Peter Eisentraut
Date:
Subject: Re: BUG #2758: missing quotes in SQL sentence