Re: [HACKERS] set search_path failure
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 particular SET search_path = public, s1; SET search_path = "public", "s1"; SET search_path = 'public', 's1'; would all be correct ways of expressing this. The other is not, and can't be because it would require excluding commas from the set of characters allowed in quoted schema names. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] set search_path failure
> 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 syntax, no? -- Tatsuo Ishii ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] set search_path failure
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 FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[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 FAQ? http://www.postgresql.org/users-lounge/docs/faq.html