On Sun, 25 Feb 2007, Tom Lane wrote: > Jeremy Drake <[EMAIL PROTECTED]> 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