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

Ascending order - Click to sort in descending order
Eric Long made changes -
Field Original Value New Value
Assignee Chris Henson [ chenson42 ] Eric Long [ elong ]
Eric Long made changes -
Status Open [ 1 ] In Progress [ 3 ]
Eric Long made changes -
Summary Support PostgreSQL 8.0 Support PostgreSQL 8.0 - fix type "e" does not exist error
Issue Type New Feature [ 2 ] Bug [ 1 ]
Fix Version/s 1.7.15 [ 16680 ]
Fix Version/s ON RADAR [ 16487 ]
Affects Version/s 2.1.0 [ 15659 ]
Affects Version/s 2.0.0 [ 16121 ]
Affects Version/s 1.7.14 [ 16655 ]
Eric Long made changes -
Fix Version/s 2.1.1 [ 16785 ]
Eric Long made changes -
Status In Progress [ 3 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Chris Henson made changes -
Status Resolved [ 5 ] Closed [ 6 ]

People

  • Assignee:
    Eric Long
    Reporter:
    Eric Long
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: