BUG in 6.5 - GROUP BY inheritance - Mailing list pgsql-hackers

From Chris Bitmead
Subject BUG in 6.5 - GROUP BY inheritance
Date
Msg-id 375F3571.B459169B@bigfoot.com
Whole thread Raw
Responses Re: [HACKERS] BUG in 6.5 - GROUP BY inheritance
List pgsql-hackers
The following query produces the following error

BUT...

if I take out the "*" from category* it starts to work. Unfortunately I
need the "*" for my purposes. Bug?

This is from CVS of about a week ago.

SELECT question.title, count(comment.oid) FROM question,
category*,comment WHERE comment.webobject = question.oid and
question.category = category.oid GROUP BY question.title;
ERROR:  replace_vars_with_subplan_refs: variable not in target list

-- 
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:chris.bitmead@bigfoot.com


pgsql-hackers by date:

Previous
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] select order by for update
Next
From: Kaare Rasmussen
Date:
Subject: Re: [HACKERS] Priorities for 6.6