Database Known Issues

Database Known Issues

PostgreSQL

Can't use string .... as an ARRAY ref while strict refs in use

In PostgreSQL 9.0 or newer, you may see an error message like this while accessing Melody:

"Can't use string ("x42494e3a53455247000000000000000") as an ARRAY ref while "strict refs" in use"

The resolution for this issue is to make a small configuration change to PostgreSQL.

1. Open postgresql.conf
2. Find the line that begins with bytea and set it to this value: bytea = 'escape'
3. Restart the PostgreSQL service (pg_ctl reload or check in the Windows services manager)