I cant find in the PG docs why it would raise this but the DISTINCT is not needed here.
On Dec 8, 2008, at 6:05 AM, Ash wrote: > > Hello , > > I am usinng sqlalchemy for making the sum on column i am using > sqlalchemy.func.sum (col_name). > > I am getting the error while dng it . > > Code snnipet > ---------------- > aggregator=sqlalchemy.func.sum('product_sold') > make_select = sqlalchemy.select(from_obj=[sales],columns= > [aggregator],distinct=True) > query = make_select.execute() > result = query.fetchall() > > > Error trace > ---------- > > query = make_select.execute() > File "/var/lib/python-support/python2.5/sqlalchemy/sql/ > expression.py", line 1087, in execute > return e.execute_clauseelement(self, multiparams, params) > File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", > line 1219, in execute_clauseelement > return connection.execute_clauseelement(elem, multiparams, params) > File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", > line 895, in execute_clauseelement > return self._execute_compiled(elem.compile(dialect=self.dialect, > column_keys=keys, inline=len(params) > 1), distilled_params=params) > File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", > line 907, in _execute_compiled > self.__execute_raw(context) > File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", > line 916, in __execute_raw > self._cursor_execute(context.cursor, context.statement, > context.parameters[0], context=context) > File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", > line 960, in _cursor_execute > self._handle_dbapi_exception(e, statement, parameters, cursor) > File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", > line 942, in _handle_dbapi_exception > raise exceptions.DBAPIError.instance(statement, parameters, e, > connection_invalidated=is_disconnect) > sqlalchemy.exceptions.ProgrammingError: (ProgrammingError) function > sum > (unknown) is not unique > > > Thanks in advance > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---