-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi there,
using SA 0.5.2/Postgres 7.4.22. Reflecting an existing database gives me this: (Pdb) c /local/HRS2/Devel/junga/tb-dev/eggs/SQLAlchemy-0.5.2-py2.4.egg/sqlalchemy/engine/base.py:1265: SAWarning: Skipped unsupported reflection of expression-based index produkt_user_idx self.dialect.reflecttable(conn, table, include_columns) 2009-02-02 08:09:07 ERROR Zope Couldn't install HaufeCMS Traceback (innermost last): Module OFS.Application, line 806, in install_product - __traceback_info__: HaufeCMS Module Products.HaufeCMS, line 80, in initialize Module Products.HaufeCMS, line 75, in setupSQLAlchemyWrappers Module haufe.hrs.bausteindb.database.setup, line 29, in setupBausteinDB Module z3c.sqlalchemy.util, line 70, in createSAWrapper Module z3c.sqlalchemy.base, line 81, in __init__ Module haufe.hrs.bausteindb.database.model, line 32, in getModel Module sqlalchemy.ext.declarative, line 543, in __init__ Module sqlalchemy.ext.declarative, line 477, in _as_declarative Module sqlalchemy.schema, line 113, in __call__ Module sqlalchemy.schema, line 241, in __init__ Module sqlalchemy.engine.base, line 1265, in reflecttable Module sqlalchemy.databases.postgres, line 658, in reflecttable Module sqlalchemy.util, line 634, in __getitem__ KeyError: u'pg_expression_2' The related table and the index are defined as follows: CREATE TABLE produkt ( id integer NOT NULL, id_produktgruppe integer, id_medium integer, redakteur character varying(50) DEFAULT ''::text, assistenz character varying(50) DEFAULT ''::text, piep character varying(50) DEFAULT ''::text, entwickler character varying(50) DEFAULT ''::text, materialnr character varying(50), id_land integer, satzdl character varying(50) DEFAULT ''::text, -- uid des Satzdienstleisters piep_sv character varying(50) DEFAULT ''::text, -- uid des Piep- Stellvertreters assistenz_sv character varying(50) DEFAULT ''::text, -- uid des Assistenz- Stellvertreters redakteur_sv character varying(50) DEFAULT ''::text, fred character varying(50) DEFAULT ''::text, fred_sv character varying(50) DEFAULT ''::text, is_big boolean DEFAULT false, piep_temp character varying(50), CONSTRAINT produkt_pkey PRIMARY KEY (id), CONSTRAINT fk_id_baustein_id FOREIGN KEY (id) REFERENCES baustein (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT fk_id_produktgruppe_produktgruppe_id FOREIGN KEY (id_produktgruppe) REFERENCES produktgruppe (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT fk_produkt_land FOREIGN KEY (id_land) REFERENCES land (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT fk_produkt_medium FOREIGN KEY (id_medium) REFERENCES medium (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION ) WITH OIDS; ALTER TABLE produkt OWNER TO postgres; GRANT ALL ON TABLE produkt TO postgres WITH GRANT OPTION; GRANT SELECT, UPDATE, INSERT ON TABLE produkt TO bausteinuser; GRANT SELECT ON TABLE produkt TO bausteinreader; GRANT SELECT ON TABLE produkt TO pcsuser; COMMENT ON COLUMN produkt.satzdl IS 'uid des Satzdienstleisters'; COMMENT ON COLUMN produkt.piep_sv IS 'uid des Piep- Stellvertreters'; COMMENT ON COLUMN produkt.assistenz_sv IS 'uid des Assistenz- Stellvertreters'; - -- Index: produkt_user_idx - -- DROP INDEX produkt_user_idx; CREATE INDEX produkt_user_idx ON produkt USING btree (lower(redakteur::text), lower(assistenz::text), lower(piep::text), lower(entwickler::text), lower(piep_sv::text), lower(assistenz_sv::text), lower(fred::text), lower(redakteur_sv::text), lower(fred_sv::text)); Andreas - -- ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany Web: www.zopyx.com - Email: i...@zopyx.com - 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 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkmGnK4ACgkQCJIWIbr9KYw+UgCfVNgspoHHorL9/qGMRzIBszUU QksAnjd+DAFU8jkDiUt2BApK9qD61ca2 =Eb8B -----END PGP SIGNATURE----- --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
begin:vcard fn:Andreas Jung n:Jung;Andreas org:ZOPYX Ltd. & Co. KG adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany email;internet:i...@zopyx.com title:CEO tel;work:+49-7071-793376 tel;fax:+49-7071-7936840 tel;home:+49-7071-793257 x-mozilla-html:FALSE url:www.zopyx.com version:2.1 end:vcard