PG: char[] field not recognized in reflection

[Former user]

I have the following table defined in PostgreSQL 8.3:

CREATE TABLE blocks ( id bigint NOT NULL, data "char"[] NOT NULL );

Trying to use reflection against this results in the following:

metadata.reflect(engine) /usr/lib/python2.5/site-packages/SQLAlchemy-0.5.1-py2.5.egg/sqlalchemy/engine/base.py:1265: SAWarning: Did not recognize type '"char"' of column 'data' self.dialect.reflecttable(conn, table, include_columns)

It should recognize it as PGArray, right?

[Mike Bayer]

unfortunately I cant reproduce this on 8.2 (unit test passes) so it seems like PG might have broken something on 8.3. although we dont use the quotes around "char", not sure if that's significant. Can you try debugging ?

[Mike Bayer]

ok we figured it out on irc, 9fc05aae02015011052ad0da2bd602951b12c071.

[Mike Bayer]

Removing milestone: 0.5.1 (automated comment)