"Dickson S. Guedes" <lis...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers