Re: Strange Prepare bug

Rod Taylor <rbt@rbt.ca> writes:
> PREPARE "pg_psql_dd2"(text,text) AS=20
> SELECT true
> FROM (
>   SELECT true
>   FROM pg_catalog.pg_proc p,
>        pg_catalog.pg_name_pattern( $2 ) AS (schpat text, propat text)
>   WHERE p.prorettype <> 'pg_catalog.cstring'::pg_catalog.regtype
> ) AS tt,
>   (SELECT $1 AS cmd) AS cmd;

> ERROR:  Parameter '$1' is out of range

I get

ERROR:  Function pg_catalog.pg_name_pattern(text) does not exist

It could be the error is inside your custom function?
        regards, tom lane