On Sunday, January 12, 2020 at 9:36:14 AM UTC-8, Carlos Correia wrote: > > Às 22:51 de 10/01/20, Dave S escreveu: > > For web2py/pydal when the backend is PostGres, are blob fields > translated to > > bytea or to large object? > > > > If bytea, does the adapter check that the value being added fits the 1G > limit > > of PostGres, or can a 2G field be sent (and then rejected by the > backend)? > > > Psycopg2 (not Web2py) maps blobs to bytea, but has the 1GB limit. > > This thread explains how to deal with that (using lo_import and > lo_export): > > > https://postgresrocks.enterprisedb.com/t5/EDB-Postgres/problems-with-writing-reading-a-data-bytea/td-p/2095 > > >
Thanks for the pointer. I'm a little disappointed the example didn't show how to use lo_import() and lo_export() in the python portion, and not just in the psql access, but it appears I can avoid that if I can guarantee fitting into 500MB. /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/bf5e6b8f-fccb-419c-a238-d95ef3891102%40googlegroups.com.
