À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
,
Regards,
Carlos Correia
=========================
MEMÓRIA PERSISTENTE
GSM: 917 157 146
e-mail: ge...@memoriapersistente.pt
URL: http://www.memoriapersistente.pt
XMPP (Jabber): car...@memoriapersistente.pt
GnuPG: wwwkeys.eu.pgp.net
--
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/d5be914a-c8c7-4d42-e12d-90493d87b215%40memoriapersistente.pt.
