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