Jeremy Drake <pgsql@jdrake.com> writes:
> psql:bogus_varattno_error.sql:23: ERROR: bogus varattno for OUTER var: 5

> Any ideas what is causing this?

This looks pretty nearly related to stuff I've been hacking on recently,
so I suppose I broke something :-(. Will take a closer look tomorrow.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

On Sun, 25 Feb 2007, Tom Lane wrote:

> Jeremy Drake <pgsql@jdrake.com> writes:
> > psql:bogus_varattno_error.sql:23: ERROR: bogus varattno for OUTER var: 5
>
> > Any ideas what is causing this?
>
> This looks pretty nearly related to stuff I've been hacking on recently,
> so I suppose I broke something :-(. Will take a closer look tomorrow.

This should help. I managed to whiddle the example down even further.

CREATE TABLE a (
a_a text
);
CREATE TABLE b (
b_a text
);

CREATE TABLE b_chld () INHERITS (b);

EXPLAIN SELECT a_a FROM a LEFT JOIN b ON a_a = lower(b_a);


Results in:
ERROR: bogus varattno for OUTER var: 2

The function call and the inheritance are both required, remove either and
it works fine.

--
This is the ____LAST time I take travel suggestions from Ray Bradbury!

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Jeremy Drake <pgsql@jdrake.com> writes:
> On Sun, 25 Feb 2007, Tom Lane wrote:
>> This looks pretty nearly related to stuff I've been hacking on recently,
>> so I suppose I broke something :-(. Will take a closer look tomorrow.

> This should help. I managed to whiddle the example down even further.

Pure brain fade :-(. Fix committed.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq