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

Re: BUG #2758: missing quotes in SQL sentence

From: Dave Page <dpage(at)postgresql(dot)org>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org, "Jim C(dot) Nasby" <jim(at)nasby(dot)net>, scoanda <sabin(dot)coanda(at)deuromedia(dot)ro>
Subject: Re: BUG #2758: missing quotes in SQL sentence
Date: 2006-11-15 08:28:08
Message-ID: 455ACF98.8000500@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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.

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.


In response to

pgsql-bugs by date

Next:From: Zdenek KotalaDate: 2006-11-15 10:17:39
Subject: Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio
Previous:From: Peter EisentrautDate: 2006-11-14 21:55:03
Subject: Re: BUG #2758: missing quotes in SQL sentence

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