Re: [HACKERS] error in cvs head: bogus varattno for OUTER var: 5
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. regards, tom lane ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] error in cvs head: bogus varattno for OUTER var: 5
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
Re: [HACKERS] error in cvs head: bogus varattno for OUTER var: 5
Jeremy Drake [EMAIL PROTECTED] 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