Author: tfischer
Date: Sun Jan 27 20:48:58 2013
New Revision: 1439176
URL: http://svn.apache.org/viewvc?rev=1439176&view=rev
Log:
Document BLOB issue for postgresql
Modified:
db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/supported-databases.xml
Modified:
db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/supported-databases.xml
URL:
http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/supported-databases.xml?rev=1439176&r1=1439175&r2=1439176&view=diff
==============================================================================
---
db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/supported-databases.xml
(original)
+++
db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/supported-databases.xml
Sun Jan 27 20:48:58 2013
@@ -169,6 +169,11 @@ CREATE TABLE book
Torque 4 was tested against PostgreSQL 9.1.
The CASCADE option for the drop table commands in the generated SQL
will only work for PostgreSQL 7.3 and later.
+ Columns declared as BLOB can not be set to null by Torque,
+ as torque maps them to BYTEA but treats them as Types.BLOB internally,
+ which is not accepted by Postgresql.
+ Use one of the other *BINARY types instead, they are all mapped to the
+ postgresql datatype BYTEA.
There are no other known issues for old PostgreSQL versions.
</p>
</subsection>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
