On 10/10/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
>
> 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.
Thanks for your answer. So basically you're saying that this
RuntimeWarning is harmless, aren't you?
Are you suggesting that I should add Geometry to postgres.py for my
specific need, or that support for this Postgres (PostGIS actually)
type should be added to SQLAlchemy?
--
Eric
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
