#5707: Aliases truncated to 64 characters on Postgres --------------------------------+------------------------------------------- Reporter: [EMAIL PROTECTED] | Owner: nobody Status: new | Component: Core framework Version: SVN | Keywords: Stage: Unreviewed | Has_patch: 0 --------------------------------+------------------------------------------- With a large join or long table names, postgres will truncate the aliases of the tables to 64 characters resulting in duplicate table names on the query. This makes the query unexecutable.
One solution is to shorten long alias names. I wrote something that modifies the alias when it is produced in db/models/query.py, but unfortunately, the join conditions get the alias as well, so the change will probably have to ultimately go into the SortedDict class to truncate and make the names unique in 64 characters there. An alternate solution would be to prefix the aliases with incrementing numbers since the truncation will still preserve unique names for the aliases. -- Ticket URL: <http://code.djangoproject.com/ticket/5707> Django Code <http://code.djangoproject.com/> The web framework for perfectionists with deadlines --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django updates" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-updates?hl=en -~----------~----~----~----~------~----~------~--~---
