The following bug has been logged online:

Bug reference: 2758
Logged by: scoanda
Email address: sabin.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

That's a pgadmin bug; please report it to them.

On Tue, Nov 14, 2006 at 03:42:53PM +0000, scoanda wrote:
--
Jim Nasby jim (AT) nasby (DOT) net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

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 to add them.

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Dave Page wrote:
Just quote them all.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Peter Eisentraut wrote:
Doesn't work:

scratch=# set search_path = '"MyNameSpace1", "MyNameSpace2"';
ERROR: schema ""MyNameSpace1", "MyNameSpace2"" does not exist

That one must be unquoted:

scratch=# set search_path = "MyNameSpace1", "MyNameSpace2";
SET

Regards, Dave.


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings