> I get
>
> ERROR: Function pg_catalog.pg_name_pattern(text) does not exist
>
> It could be the error is inside your custom function?
I forgot that is a new function :)
Try this one:
PREPARE "pg_psql_dd2"(text,text) AS
SELECT true
FROM (
SELECT true
FROM pg_catalog.pg_proc p,
(SE
Rod Taylor <[EMAIL PROTECTED]> 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,
I've trimmed this query down as much as possible (started out much
larger), it no longer causes the error.
PREPARE "pg_psql_dd2"(text,text) AS
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
