Re: [ZODB-Dev] Relstorage Blob support and Oracle

2011-06-15 Thread Martijn Pieters
On Wed, Jun 15, 2011 at 21:40, Shane Hathaway wrote: > Cool!  I'll apply your migration script to my buildbots and report back. >  Right now (before migrating) all the bots fail. ;-) Whoops! :-) I tested the migrations on some test data, so they should work on your databases without issue. -- M

Re: [ZODB-Dev] Relstorage Blob support and Oracle

2011-06-15 Thread Shane Hathaway
On 06/15/2011 11:41 AM, Martijn Pieters wrote: > On Wed, Jun 15, 2011 at 16:23, Martijn Pieters wrote: >>> Last but not least I'll need to write a migration script for those >>> users of RelStorage 1.5.0b2 already in production. >> >> I have figured out how to do this (see >> http://archives.postg

Re: [ZODB-Dev] Relstorage Blob support and Oracle

2011-06-15 Thread Martijn Pieters
On Wed, Jun 15, 2011 at 16:23, Martijn Pieters wrote: >> Last but not least I'll need to write a migration script for those >> users of RelStorage 1.5.0b2 already in production. > > I have figured out how to do this (see > http://archives.postgresql.org/pgsql-general/2009-01/msg00771.php). I > won

Re: [ZODB-Dev] Relstorage Blob support and Oracle

2011-06-15 Thread Martijn Pieters
On Tue, Jun 14, 2011 at 22:22, Martijn Pieters wrote: > I am considering altering the ON COMMIT behaviour of the > temp_blob_chunk table to TRUNCATE to extend this behaviour to all > remaining blob rows on commit. However, such events should be rare > enough, and there is a `vacuumlo` command that