On Fri, Nov 4, 2011 at 16:04, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Magnus Hagander <magnus@hagander.net> writes:
>> Updated patch attached that does this, and the proper schema qualifications.
>
> I'd schema-qualify the quote_ident and regclass names too.
>
> Also, just as a matter of style, I think it'd be better to assign short
> aliases to the table names ("pg_catalog.pg_class c" etc) and use those.
> I forget what the letter of the SQL standard is about whether an
> un-aliased schema-qualified table name can be referenced in the query
> without schema-qualifying the reference, but I'm pretty sure that not
> doing so is at least frowned on.
Fixed, and applied.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/