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
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: > 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
[HACKERS] error in cvs head: bogus varattno for OUTER var: 5
The attached sql file creates some table infrastructure and then tries to explain a query. I get the following error on CVS HEAD: psql:bogus_varattno_error.sql:23: ERROR: bogus varattno for OUTER var: 5 In my real data, when I attempt to run the query I get the error: ERROR: invalid attribute number 5 But in the test setup it just returns an empty set. Any ideas what is causing this? Is it my query, or is something broken somewhere? I tend to think the latter, since this error message does not feel like one that a user would get and be expected to know what to do with... -- If God had intended Man to Watch TV, He would have given him Rabbit Ears.CREATE TABLE filenames ( recdate timestamp NOT NULL, season smallint NOT NULL, partno smallint, station text NOT NULL, eptitle text NOT NULL ); CREATE TABLE episodes ( epnum text NOT NULL, season smallint NOT NULL, title text NOT NULL, partno smallint ); CREATE TABLE episodes_chld () INHERITS (episodes); \set tsearch_sql `pg_config --sharedir`/contrib/tsearch2.sql \i :tsearch_sql EXPLAIN SELECT epnum, filenames.* FROM filenames LEFT JOIN episodes ON ( filenames.season = episodes.season AND strip(to_tsvector(filenames.eptitle)) = strip(to_tsvector(episodes.title)) AND filenames.partno IS NOT DISTINCT FROM episodes.partno) WHERE epnum IS NULL; -- vim: set ft=psql ts=2 sw=2 expandtab : ---(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