Port Bug Report: Non alphanumeric characters in a text string - Mailing list pgsql-ports

From Unprivileged user
Subject Port Bug Report: Non alphanumeric characters in a text string
Date
Msg-id 199901150112.UAA10839@hub.org
Whole thread Raw
List pgsql-ports
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        : Cullin Wible
Your email address    : cwible@tlgm.com

Category        : runtime: back-end
Severity        : non-critical

Summary: Non alphanumeric characters in a text string

System Configuration
--------------------
  Operating System   : Linux 2.0.34 ELF RedHat

  PostgreSQL version : 6.3.2-4

  Compiler used      : 2.7.2.3

Hardware:
---------
Pentium II 266Mhz, 64MB Ram, SCSI2 9GB Drive
Linux swdev.tlgm.com 2.0.34 #1 Fri May 8 16:05:57 EDT 1998 i686 unknown

Versions of other tools:
------------------------


--------------------------------------------------------------------------

Problem Description:
--------------------
When trying to insert non-alphanumeric characters in a string
such as "\" it becomes necessary to back quote them. This
works fine, for example "\%" becomes "%" in the database, however
a "\\" stays as it is. THis makes it impossible to ever end
up with the text "\*" in the databse. If you try the logical
"\\\*" to do that, it results in "\\*" which is not what I wanted.


--------------------------------------------------------------------------

Test Case:
----------
Try inserting any data in the above format.

--------------------------------------------------------------------------

Solution:
---------
Fix the function wich un-does the back quoteing.

--------------------------------------------------------------------------


pgsql-ports by date:

Previous
From: Thien Lee
Date:
Subject: Installed PostgreSQL
Next
From: Unprivileged user
Date:
Subject: Port Bug Report: psql can't work correctly