-----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-----
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
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
