On Oct 10, 2007, at 10:01 AM, Eric Lemoine wrote:
> > Hi > > I use a reflected table with an overriden column: > > summits_table = Table('sommets_out', > MetaData(config['pylons.g'].sa_search_engine), > Column('geom', Geometry), > autoload=True) > > and I get RuntimeWarning when accessing the table: > > /home/elemoine/virtual-python/lib/python2.4/site-packages/ > SQLAlchemy-0.4.0beta6-py2.4.egg/sqlalchemy/databases/postgres.py:446: > RuntimeWarning: Did not recognize type 'geometry' of column 'geom' > > Is this behavior expected? it is, Postgres is reporting "geometry" as the type of the column and we dont have that type available within postgres.py; so it replaces it with the NullType. Afterwards, your overridden Column replaces it (i.e. post-reflection), so it all works out. Better solution, would be to add your Geomtry type to postgres.py. --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---