Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> The man page says:
>SET variable { TO | = } { value | 'value' | DEFAULT }
> So user naturally thinks
> set search_path to 'public,s1';
> is a correct syntax, no?
The man page needs improvement --- some variables accept a list of
values now. In
> Try 'public','s1' perhaps...
Wao, this is confusing:-)
The man page says:
SET variable { TO | = } { value | 'value' | DEFAULT }
And:
test=# show search_path;
search_path
-
public, s1
(1 row)
So user naturally thinks
set search_path to 'public,s1';
is a correct synta
Try 'public','s1' perhaps...
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Tatsuo Ishii
> Sent: Monday, 19 August 2002 2:31 PM
> To: [EMAIL PROTECTED]
> Subject: [HACKERS] set search_path failure
>
I'm seeing this:
test=# create schema s1;
CREATE SCHEMA
test=# set search_path to 'public, s1';
ERROR: Namespace "public, s1" does not exist
Am I missing something?
--
Tatsuo Ishii
---(end of broadcast)---
TIP 5: Have you checked our extensive FA