Re: [pysqlite] [apsw] ReadOnlyError when closing read-only blobs?

Roger Binns <[email protected]> Tue, 01 Sep 2009 19:22:09 +0530
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Austin Bingham wrote:
> I've found that Blob.close() throws a ReadOnlyError if I've previously
> attempted to perform a write on that blob. I was surprised by this,
> but I wanted to see if this is expected behavior.

It is indeed the "correct" behaviour.  It is SQLite that does this.  I
actually use this as part of the test suite since it was the only way I
could think of deliberately causing an error on a read only blob.

This is alluded to in
http://apsw.googlecode.com/svn/publish/blob.html#apsw.blob.close

I have since updated the documentation to mention this specific example
and blame SQLite :-)

Roger

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkqdJwgACgkQmOOfHg372QRAxACgvTATM5VxqF3Jptt0cUHIN7O4
FgMAn1u0oNh8BINEGi6gEnRcJEo0AjLy
=1iTy
-----END PGP SIGNATURE-----