Hi,

Is there a way to use the native PostgreSQL (i.e. not postgis) "polygon" 
data type through SQLAlchemy? I'm guessing one might be able to define the 
model class via autoload as normal, then add some kind of custom column 
definition? Surely someone has done this before, but I haven't been able to 
find an example.

I've taken a look at geoalchemy and tried to implement that, but was 
getting this error:

ProgrammingError: (psycopg2.ProgrammingError) function st_asbinary(polygon) 
does not exist
LINE 1: ....sdss_frame.filename AS muna_sdss_frame_filename, ST_AsBinar...
                                                             ^
HINT:  No function matches the given name and argument types. You might 
need to add explicit type casts.

If at all possible, I'd prefer to use the native data type, even if it 
requires a custom adaptor. (Again, surely someone has written this?)

Cheers,
Demitri

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to