DdlUtils
  1. DdlUtils
  2. DDLUTILS-165

Data type mismatch in PostgreSQL with TEXT columns

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.0 RC1
    • Component/s: Core - PostgreSql
    • Labels:
      None
    • Environment:
      PostgreSQL v2.8.3 on Windows with JDBC driver 'postgresql-8.2-504.jdbc3.jar'

      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).

      1. patch.txt
        1 kB
        Martin van den Bemt

        Activity

        Stefan Huber created issue -
        Thomas Dudziak made changes -
        Field Original Value New Value
        Fix Version/s 1.0 [ 12310891 ]
        Martin van den Bemt made changes -
        Attachment patch.txt [ 12354149 ]
        Martin van den Bemt made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Thomas Dudziak made changes -
        Fix Version/s 1.0 RC1 [ 12312482 ]
        Fix Version/s 1.0 [ 12310891 ]

          People

          • Assignee:
            Thomas Dudziak
            Reporter:
            Stefan Huber
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development