| From: | Joe Abbate <jma(at)freedomcircle(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us |
| Subject: | Re: regclass and search_path |
| Date: | 2011-03-18 04:49:44 |
| Message-ID: | 4D82E468.3080309@freedomcircle.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adarsh Sharma | 2011-03-18 07:00:50 | Convert Simple Query into tsvector & tsquery format. |
| Previous Message | Joe Abbate | 2011-03-18 04:42:49 | Re: regclass and search_path |