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

Reply via email to