Hi,
Was there a change in the PostgreSQL server for how BYTEA fields are defined in a SQL Query to the server?
I am using a PostgreSQL 9.1 server and the following query is perfectly valid for a BYTEA type column:
INSERT INTO files VALUES(18,'\x536f6d6520746573742062797465206172726179');
But for a server running version 9.3 the above query fails with the following error:
ERROR: array value must start with "{" or dimension information
LINE 1: insert into files values(18,'\x504b030414000600080000002100e...
Is this something that changed on the server from 9.1 to 9.3 or is it based on a setting somewhere that could affect this?
This problem was picked up during a conversation on a Qt Forum that can be seen
here. I am trying to find out where the solution should be to make the Qt code and the PostgreSQL server compatible again for a proper bug report (if needed) at the correct place.
Regards,