On Jan 21, 2010, at 9:57 AM, Tom Lane wrote:
> Schema names of what? It sounds to me like you're failing to use the
> existing regfoo types in appropriate places ...
The names of schemas in which to find functions, tables, views, triggers, etc. etc. I have lots of stuff like this:
SELECT true FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON n.oid = c.relnamespace
WHERE c.relkind = $1 AND n.nspname = $2 AND c.relname = $3
I'd love to instead do something like:
SELECT true FROM pg_catalog.pg_class c WHERE c.relkind = $1 AND
c.relnamespace::regschema= $2 AND c.relname = $3
Best,
David