Re: ERROR: "failed to locate grouping columns"
От | Dickson S. Guedes |
---|---|
Тема | Re: ERROR: "failed to locate grouping columns" |
Дата | |
Msg-id | 1236544161.20435.277.camel@guedes-laptop обсуждение исходный текст |
Ответ на | Re: ERROR: "failed to locate grouping columns" (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: ERROR: "failed to locate grouping columns"
Re: ERROR: "failed to locate grouping columns" |
Список | pgsql-hackers |
Em Sáb, 2009-03-07 às 19:38 -0500, Tom Lane escreveu: > I really have a hard time believing that whether you get that error is > contingent on whether the view returns some rows or not. That's a > planner message and couldn't possibly have to do with what happens > at runtime. Well, today I have more time to study the environment and I'd see that was a coincidence in the fact that when the grouping by in the view works fine and it was returning values, it was tested in a 8.1.4 PG version. Now I made a complete test in 8.1.4 and 8.3.6. In the first the error not occurs, in the last yes. > 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_cnt_vnc_tst -> is my view before I changed sub-selects to JOIN vw_that_works - an example view that works without grouping some columns vw_that_not_works -> an example view that throws an error thanks. -- Dickson S. Guedes - mail/xmpp: guedes@guedesoft.net - skype: guediz http://guedesoft.net - http://planeta.postgresql.org.br
Вложения
В списке pgsql-hackers по дате отправления: