Re: Do FROM items of different schemas conflict?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fernando Nasser <fnasser(at)redhat(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Do FROM items of different schemas conflict?
Date: 2002-03-09 00:29:29
Message-ID: 27622.1015633769@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Fernando Nasser <fnasser(at)redhat(dot)com> writes:
> The POSTQUEL extension of adding the tables for you (if I understood
> right) is an aberration (if it is still supported it will ave to be
> removed).

No it won't. The implicit-RTE extension doesn't come into play until
after you've failed to find a matching RTE. It cannot break queries
that are valid according to spec --- it only affects queries that should
flag an error according to spec.

My question is about what it means to find a matching RTE and when two
similarly-named RTEs should be rejected as posing a name conflict.
Implicit RTEs are not relevant to the problem.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2002-03-09 00:30:15 Re: Do FROM items of different schemas conflict?
Previous Message Tom Lane 2002-03-09 00:19:47 Re: Do FROM items of different schemas conflict?