Re: set search_path failure

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: chriskl(at)familyhealth(dot)com(dot)au
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: set search_path failure
Date: 2002-08-19 06:51:21
Message-ID: 20020819.155121.115904319.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gavin Sherry 2002-08-19 07:03:18 Re: Function result cacheing - any comments?
Previous Message Christopher Kings-Lynne 2002-08-19 06:41:23 Re: set search_path failure