select function & search_path problem/bug?

From: ivan <iv(at)psycho(dot)pl>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: select function & search_path problem/bug?
Date: 2004-08-20 10:29:32
Message-ID: Pine.LNX.4.58.0408201224060.30398@rex.anfa.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


hi,

i have a problem with selecting function :

db=# select auxilium.exists('arx.mods', 'r');
exists
--------
t
(1 row)

db=# select exists('arx.mods', 'r');
ERROR: syntax error at or near "'arx.mods'" at character 15
db=# show search_path;
search_path
---------------------------
auxilium, pg_catalog, arx
(1 row)

why i have to give namespace name, when i have it already in search_path
?

(its in pg 7.4.3 and 8.0)

thanks

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Huxton 2004-08-20 10:39:02 Re: select function & search_path problem/bug?
Previous Message Gaetano Mendola 2004-08-20 09:41:00 Re: postgres uptime