| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Strange Prepare bug |
| Date: | 2003-01-29 12:52:29 |
| Message-ID: | 1043844749.76461.94.camel@jester |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2003-01-29 13:17:37 | Re: Please include hier-patch in next PostgreSQL version |
| Previous Message | Luis Alberto Amigo Navarro | 2003-01-29 12:12:41 | signal handling |