SymmetricDS
  1. SymmetricDS
  2. SYMMETRICDS-353

Support PostgreSQL 8.0 - fix type "e" does not exist error

    Details

    • Type: Bug Bug
    • Status: Closed Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 1.7.14, 2.0.0, 2.1.0
    • Fix Version/s: 1.7.15, 2.1.1
    • Component/s: DB Dialect Postgresql
    • Labels:
      None
    • Number of attachments :
      0

      Description

      SymmetricDS is using escape syntax in the SQL by writing the letter E before the string and using special backslash characters. This escape syntax does not work on versions of PostgreSQL before 8.2. On early versions, the user gets the error:

      org.postgresql.util.PSQLException: ERROR: type "e" does not exist

      Add support for PostgreSQL 8.0, either by using a different escape syntax (see dollar quoted strings) or by using a separate dialect.

      http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html

        Activity

        Hide
        Eric Long added a comment -

        Apparently, SymmetricDS 1.6 works on PostgreSQL 8.0, even though we haven't been testing against that version. We broke it when we added the "e" escape syntax while fixing another bug. I changed the trigger creation SQL to use dollar quoted escape syntax instead. The user reported that PostgreSQL 8.0 is working for them now with the snapshot.

        Show
        Eric Long added a comment - Apparently, SymmetricDS 1.6 works on PostgreSQL 8.0, even though we haven't been testing against that version. We broke it when we added the "e" escape syntax while fixing another bug. I changed the trigger creation SQL to use dollar quoted escape syntax instead. The user reported that PostgreSQL 8.0 is working for them now with the snapshot.

          People

          • Assignee:
            Eric Long
            Reporter:
            Eric Long
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: