[DDLUTILS-165] Data type mismatch in PostgreSQL with TEXT columns

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.0 RC1
• Component/s: Core - PostgreSql
• Environment: PostgreSQL v2.8.3 on Windows with JDBC driver 'postgresql-8.2-504.jdbc3.jar'
• Assignee: Thomas Dudziak
• Reporter: Stefan Huber
• Created: 20/Mar/07 14:47
• Updated: 04/Jun/07 02:33
• Resolved: 29/Mar/07 18:36

Description

The PostgreSql jdbc driver returns VARCHAR(2147483647) for columns defined as TEXT. The ModelReader expects VARCHAR(-1) for these data type.
Maybe the behaviour of the jdbc driver changed lately, because there is a comment in the PostgreSqlModelReader.readColumn method which says that PostgreSQL returns VARCHAR(-1), but in my environment i get VARCHAR(2147483647).