Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-11459

Blob escape in postgresql (qpsql) driver

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Out of scope
    • Icon: P3: Somewhat important P3: Somewhat important
    • Some future release
    • 4.6.3
    • SQL Support
    • None
    • PostgreSQL 8.3+ (But as i read it, it's an issue with 8.2 too)
      Debian 5 64-bit

      Insert of blob (bytea) into postgresql results in:

      WARNING:  nonstandard use of \\ in a string literal

      Where \ \ could be a number of different escape-sequences.

      Apparently the correct way to escape this is: "E'\ \....'::bytea" according to http://www.postgresql.org/docs/8.2/static/datatype-binary.html

      Patch supplied

        1. psql.patch
          1 kB
        For Gerrit Dashboard: QTBUG-11459
        # Subject Branch Project Status CR V
        94748,1 Add the E for escaped strings when using PSQL version 8 or older 5.4 qt/qtbase Status: ABANDONED -1 0

            andysh Andy Shaw
            mb@dbc.dk Morten Bogeskov
            Votes:
            5 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved:

                There are no open Gerrit changes