Ticket #302 (closed defect: fixed)

Opened 6 years ago

Last modified 6 years ago

PostgresSQL can't cast CHAR to BYTEA

Reported by: rjl Owned by: rjl
Priority: normal Milestone: 1.0.2
Component: SQL scripts Version: 1.0.1
Severity: normal Keywords: postgresql bytea
Cc:

Description

The 9.php part of the upgrade script fails for PostgreSQL users when it attempts to cast the token column of the bayes_token table from CHAR(5) to BYTEA. PostgreSQL requires that text strings be decoded and escaped for backslashes before they can be converted to BYTEA types.

Change History

Changed 6 years ago by rjl

  • status changed from new to closed
  • resolution set to fixed

Should be fixed in [1019], which does the conversions the hard way.

Note: See TracTickets for help on using tickets.