Re: Patch: regschema OID type

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