thanks for the test, this is fixed in r5772. On Feb 2, 2009, at 2:11 AM, Andreas Jung wrote:
> -----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: [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 > > -----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----- > > > > 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:[email protected] > 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 > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" 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/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
