Re: ERROR: "failed to locate grouping columns"

Em Sáb, 2009-03-07 às 19:38 -0500, Tom Lane escreveu:
> "Dickson S. Guedes" <listas(at)guedesoft(dot)net> writes:
> > And bellow is the select that returns: "ERROR: failed to locate grouping columns"
> > when no rows is returned by the View above, but it runs well when one or more
> > rows is returned by same view.
>
> 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.

And I was really confused when I've tested. I've seen that it's a
planner message, then I discard SUBSELECTs and use JOINs and it works.

> Would you put together a complete example, instead of leaving us to
> guess what's underlying the view?

Ok, I'll prepare a full test and send it.

> And what PG version is this?

Oh! I forgot to say, the version is 8.3.6.

Thanks.
--
Dickson S. Guedes
-
mail/xmpp: guedes(at)guedesoft(dot)net - skype: guediz
http://guedesoft.net - http://planeta.postgresql.org.br