oops, I forgot to check in 1 file, its in there now.

Thanks for letting me know.

That procedure is in the script in svn.
3mojoPortal.PostgreSQL.CreateStoredProcedures.sql

I just searched my copy and it is there and my copy is not different than the version currently in svn.

re-run that script on your db to create the missing procedure(s).

select drop_type('mp_friendlyurls_selectbyhost_type');
CREATE TYPE public.mp_friendlyurls_selectbyhost_type as (
    urlid int4,
    siteid int4,
    friendlyurl varchar(255),
    realurl varchar(255),
    ispattern bool
);

create or replace function mp_friendlyurls_selectbyhost(
    varchar(255) --:hostname $1
) returns setof mp_friendlyurls_selectbyhost_type
as '

select
        urlid,
        siteid,
        friendlyurl,
        realurl,
        ispattern
from
        mp_friendlyurls
where   siteid = coalesce(    (select siteid from mp_sitehosts where hostname = $1 limit 1),
                 (select siteid from mp_sites order by siteid limit 1)
            ) ;'   
security definer language sql;
grant execute on function mp_friendlyurls_selectbyhost(
    varchar(255) --:hostname $1
) to public;


Joe