SymmetricDS

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
Permalink
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
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: