Hi,
I've been trying out tesla, specifically tesla_auth, by following the
'getting started' on the tesla wiki. When I get to the 'paster
create_sql development.ini' section, paste falls over with the
following error:
"
An unknown error occurred. (ProgrammingError) relation
"example_model_user_permission_groups__example_model_user_group_"
already exists
'\nCREATE TABLE
example_model_user_permission_groups__example_model_user_group_permissio
ns (\n\texample_model_user_permission_id INTEGER, \n
\texample_model_user_group_id INTEGER, \n\t CONSTRAINT
example_model_user_permission_groups_fk FOREIGN KEY
(example_model_user_permission_id) REFERENCES
example_model_user_permission (id), \n\t CONSTRAINT
example_model_user_group_permissions_fk FOREIGN KEY
(example_model_user_group_id) REFERENCES example_model_user_group (id)
\n)\n\n' {}
"
A quick check shows that the table names are simply too long,
resulting in clashing tables (eg, 'blah...blah' and
'blah...blah_id_seq' are the same, as the latter gets shortened).
Other than going the other way and reflect the tables from the
database, is there a solution to this? Would I need to recompile
postgresql to allow for longer table names (which wouldn't very
portable, which would then also unfortunately apply to tesla)?
Specs: python 2.5, postgresql 8.2.4, sqlalchemy 0.3.9, tesla 2.5
Cheers,
Evert
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"pylons-discuss" 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/pylons-discuss?hl=en
-~----------~----~----~----~------~----~------~--~---
