Re: regclass and search_path - Mailing list pgsql-general

HI Tom,

On 03/18/2011 12:42 AM, Joe Abbate wrote:
> For my immediate needs, the query was actually the target of a NOT IN
> subquery of a query against pg_index (trying to exclude tuples of
> indexes for UNIQUE constraints) and I've solved that by using conrelid
> in the subquery (and indrelid in the main query).  Nevertheless, I
> think regclass should probably be smarter and work with anything in
> pg_class (regardless of search_path).

On second thought, conname is just a "name", is not unique and is
lacking schema/namespace info. As you said, a thinko.

Regards,

Joe