Re: ERROR: "failed to locate grouping columns" - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ERROR: "failed to locate grouping columns"
Date
Msg-id 2260.1236544452@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: "failed to locate grouping columns"  ("Dickson S. Guedes" <listas@guedesoft.net>)
List pgsql-hackers
"Dickson S. Guedes" <listas@guedesoft.net> writes:
> Em Sáb, 2009-03-07 às 19:38 -0500, Tom Lane escreveu:
>> Would you put together a complete example, instead of leaving us to
>> guess what's underlying the view?  And what PG version is this?

> Attached there is a dump with the tables and views related:
> vw_that_works - an example view that works without grouping some columns
> vw_that_not_works -> an example view that throws an error

OK, reproduced here on HEAD:

dg=# select * from vw_that_not_works;
ERROR:  failed to locate grouping columns

Off to do some debugging.  Thanks for the test case!
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Dickson S. Guedes"
Date:
Subject: Re: ERROR: "failed to locate grouping columns"
Next
From: Tom Lane
Date:
Subject: Re: status of remaining patches