I think @Leonel Câmara <leonelcam...@gmail.com> would know best what is
going on here.

My uneducated guess is that you are using Postgresql12 and that there were
some major changes from postgres11 to postgres12.
Either Pydal has not caught up yet, or since pydal is not strictly an ORM,
you just have to actually adapt your pydal statements a bit.

Try this:

for grp in db((db.pay_ins_stack.ref_==db.pay_ins.id)
                & (db.pay_ins.ref_ == db.deal_acc_addrs.id )
                & (db.deal_acc_addrs.xcurr_id == xcurr.id)
                        ).select(groupby=(db.deal_acc_addrs.id),
pay_ins_stack.id):



Am Sa., 14. Nov. 2020 um 09:35 Uhr schrieb Dmitrii Ermolaev <
ermolaev.icrea...@gmail.com>:

>
> for grp in db((db.pay_ins_stack.ref_==db.pay_ins.id)
>                 & (db.pay_ins.ref_ == db.deal_acc_addrs.id )
>                 & (db.deal_acc_addrs.xcurr_id == xcurr.id)
>                         ).select(groupby=(db.deal_acc_addrs.id)):
>
> ERROR:
> column "pay_ins_stack.id" must appear in the GROUP BY clause or be used
> in an aggregate function LINE 1: SELECT "pay_ins_stack"."id",
> "pay_ins_stack"."ref_", "pay_in...
>
> With MySQL all work good !
>
> help please!
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/c392a3bc-f748-468a-b74c-5c15fef6d20fn%40googlegroups.com
> <https://groups.google.com/d/msgid/web2py/c392a3bc-f748-468a-b74c-5c15fef6d20fn%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CADHCKLQWBDmbJJVj6LGzU4uvz%3D7Ems5pPNvXH1DpX7UeZwv4Sg%40mail.gmail.com.

Reply via email to