From: Andreas Jung <[EMAIL PROTECTED]> To: sqlalchemy@googlegroups.com Subject: engine.base._convert_key() fails with long col names Date-Sent: 14. Juni 2007 15:14:37
Hi, I am getting the following traceback * Module toolbox.product.export_bauplan2, line 96, in export_bauplan * Module toolbox.product.export_bauplan2, line 69, in xml_builder * Module toolbox.product.export_bauplan2, line 27, in xml_builder * Module toolbox.database.model, line 60, in tools * Module sqlalchemy.orm.attributes, line 53, in __get__ * Module sqlalchemy.orm.attributes, line 208, in get * Module sqlalchemy.orm.strategies, line 226, in lazyload * Module sqlalchemy.orm.query, line 326, in select_whereclause * Module sqlalchemy.orm.query, line 955, in _select_statement * Module sqlalchemy.orm.query, line 857, in execute * Module sqlalchemy.orm.query, line 916, in instances * Module sqlalchemy.orm.mapper, line 1471, in _instance * Module sqlalchemy.orm.mapper, line 1508, in populate_instance * Module sqlalchemy.orm.interfaces, line 163, in execute * Module sqlalchemy.orm.strategies, line 39, in process_row * Module sqlalchemy.engine.base, line 1174, in __getitem__ * Module sqlalchemy.engine.base, line 995, in _get_col * Module sqlalchemy.engine.base, line 932, in _convert_keyNoSuchColumnError: "Could not locate column in row for column 'Column(u'stammdatenverwaltung_tauglich',PGBoolean())'"
This happens when _convert_key() is called with key='arbeitsmittelhierarchy_arbeitsmittel_view.stammdatenverwaltung_tauglich' When I look at the self._ResultProxy__keys then the key cache contains shortend col names: (Pdb) for x in self._ResultProxy__keys:print x arbeitsmittelhierarchy_arbeitsmittel_view_idautor arbeitsmittelhierarchy_arbeitsmittel_view_idsachgebiet arbeitsmittelhierarchy_arbeitsmittel_view_num_hre arbeitsmittelhierarchy_arbeitsmittel_view_bemerkung arbeitsmittelhierarchy_arbeitsmittel_view_versionsnr arbeitsmittelhierarchy_arbeitsmittel_view_idzielgruppe arbeitsmittelhierarchy_arbeitsmittel_view_idfassung arbeitsmittelhierarchy_arbeitsmittel_view_dateiname arbeitsmittelhierarchy_arbeitsmittel_view_originalname arbeitsmittelhierarchy_arbeitsmittel_view_rechnerstand arbeitsmittelhierarchy_arbeitsmittel_view_id arbeitsmittelhierarchy_arbeitsmittel_view_hidx_master arbeitsmittelhierarchy_arbeitsmittel_view_stammdatenverwaltung_ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Using SA 0.3.8 and Postgres 7.4.7...what's the suggested way to get around this issue (shortening the column names isn't an option). Andreas -- ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376 Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535 Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK ------------------------------------------------------------------------ E-Publishing, Python, Zope & Plone development, Consulting
pgp3TcNEphdFD.pgp
Description: PGP signature