Peter Eisentraut wrote:
> Dave Page wrote:
>> 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.
> Just quote them all.
scratch=# set search_path = '"MyNameSpace1", "MyNameSpace2"';
ERROR: schema ""MyNameSpace1", "MyNameSpace2"" does not exist
That one must be unquoted:
scratch=# set search_path = "MyNameSpace1", "MyNameSpace2";
In response to
pgsql-bugs by date
|Next:||From: Zdenek Kotala||Date: 2006-11-15 10:17:39|
|Subject: Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio|
|Previous:||From: Peter Eisentraut||Date: 2006-11-14 21:55:03|
|Subject: Re: BUG #2758: missing quotes in SQL sentence|