Re: Trouble Accessing Schema-Qualified Table

On Mon, Nov 15, 2010 at 8:35 AM, Jerry Richards
<jerry.richards@teotech.com> wrote:
>
> teo=# select * from sip_presence('ts_sofia_internal') where
> sip_presence.sip_user='1003';
>
> ERROR:  function sip_presence(unknown) does not exist
>
> LINE 1: select * from sip_presence('ts_sofia_internal') where sip_pr...
>                       ^
> HINT:  No function matches the given name and argument types. You might need
> to add explicit type casts.

The problem isn't the schema name, it is with the parameter you are
using in your function. Since you don't show the definition of your
function, I'm going to take a guess and assume your input
'ts_sofia_internal' is a TEXT type, so you might do something like:

select * from sip_presence('ts_sofia_internal'::TEXT) where ...

If not "TEXT" type, check your function to see what it expects the type to be

\df sip_presence