On Friday 06 March 2009 06:21:29 pm Ed Leafe wrote:
> On Mar 6, 2009, at 3:42 PM, johnf wrote:
> > When using statements like
> > "select somefield in dataset "
> > SQLite might error on an unsupported datatype of the database you
> > are using.
> >
> > In my case the data type was "bytea" on Postgres. However, I got no
> > traceback
> > or db log. It took a while determine what was going on.
>
> When you do a select on a dataset, an in-memory SQLite database is
> created from the Python data. I'm guessing that whatever 'bytea' is in
> PostgreSQL, the Python type that held was not able to be inserted into
> the SQLite temp database.
>
> Can you tell me what type the 'bytea' column was in Python?
>
>
> -- Ed Leafe
Not sure what it was translated to for the python but in Dabo
elif "bytea" in fldType:
fldType = "L"
It's a variable-length binary string in Postgres. I was going to use the
field to hold maps. Haven't used it so I don't really know if it works.
--
John Fabiani
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
