Issue #3 resolved

(ProgrammingError) could not identify an ordering operator for type record HINT

Evgeniy Tatarkin
created an issue

After update sqlalchemy from 0.5.8 to 0.6.6 on code: {{{ ProviderGroup.mp.query_all_trees(Session()) }}}

Raised: {{{ProgrammingError: (ProgrammingError) could not identify an ordering operator for type record HINT: Use an explicit ordering operator or modify the query. 'SELECT <SKIPPED> ORDER BY (provider_group.mp_tree_id, provider_group.mp_path), (provider_group.mp_tree_id, provider_group.mp_path)' {}}}}

My environment: python 2.5 sqlalchemy 0.6.6 sqlamp 0.5.2 postgres 8.3

My solution use in //MPClassManager.query_all_trees//:

{{{order_by(self.clause_element())}}}

instead of

{{{order_by(self)}}}

Comments (1)

  1. angri repo owner

    Please, upgrade to the tip version of sqlamp and don't use this kind of ordering - it was a big hack all the time until its removal.

  2. Log in to comment