Pg is not a toy like mysql It always required an explicit notation for groupby воскресенье, 15 ноября 2020 г. в 11:18:55 UTC+3, ermolaev...@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, > db.pay_ins_stack.id)): > > same error: > column "pay_ins.id" must appear in the GROUP BY clause or be used in an > aggregate function LINE 1: ..._ins_stack"."tries", > "pay_ins_stack"."to_refuse", "pay_ins".... ^ > > суббота, 14 ноября 2020 г. в 12:32:08 UTC+3, kell...@gmail.com: > >> I think @Leonel Câmara 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...@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+un...@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/7cba6429-d5e1-4ae8-82ab-6ef0cf59f640n%40googlegroups.com.
