From: | Carel Combrink <carel(dot)combrink(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | BYTEA: PostgreSQL 9.1 vs 9.3 |
Date: | 2014-01-30 06:50:02 |
Message-ID: | CAAxNqarOGOzdJ46Smv-GBXB3rkSme5610nq5ZCDhnd1oJdU54Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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 <http://qt-project.org/forums/viewthread/37650/>. 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,
From | Date | Subject | |
---|---|---|---|
Next Message | James David Smith | 2014-01-30 11:19:30 | Re: Update with last known location? |
Previous Message | Erik Darling | 2014-01-29 22:10:09 | Re: Update with last known location? |