[web2py] Re: Cannot insert into postgres database, starting with a 1.1M blob.

2017-08-23 Thread Ben Lawrence
Ok, i have a very rough fix. (Thanks Leonel for your time) I neglected to say that this is all done by the scheduler. What I did was insert time.sleep(5) between the commits, as well as inserting a half the attachment size first. This seems to work (I still need to optimize the wait times):

[web2py] Re: Cannot insert into postgres database, starting with a 1.1M blob.

2017-08-22 Thread Leonel Câmara
Depending on the database a blob field may not be able to hold more than 64KB You can look in https://github.com/web2py/pydal/blob/master/pydal/dialects Open the .py for the database you are using and search for @sqltype_for('blob') def type_blob(self): To see what type you are