Re: Strange Prepare bug - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: Strange Prepare bug
Date
Msg-id 1043844749.76461.94.camel@jester
Whole thread Raw
In response to Re: Strange Prepare bug  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> 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,      (SELECT substr($2, 1, 3) as schpat, substr($2, 3, 5) as propat)
as t WHERE p.prorettype <> 'pg_catalog.cstring'::pg_catalog.regtype
) AS tt, (SELECT $1 AS cmd) AS cmd

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

pgsql-hackers by date:

Previous
From: "Luis Alberto Amigo Navarro"
Date:
Subject: signal handling
Next
From: Rod Taylor
Date:
Subject: Re: Please include hier-patch in next PostgreSQL version