BYTEA: PostgreSQL 9.1 vs 9.3

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,

Responses

Browse pgsql-novice by date

  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?