Port Bug Report: Non alphanumeric characters in a text string

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgresql(dot)org
Subject: Port Bug Report: Non alphanumeric characters in a text string
Date: 1999-01-15 01:12:42
Message-ID: 199901150112.UAA10839@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports


============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Cullin Wible
Your email address : cwible(at)tlgm(dot)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.

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

Browse pgsql-ports by date

  From Date Subject
Next Message Unprivileged user 1999-01-15 12:33:32 Port Bug Report: psql can't work correctly
Previous Message Thien Lee 1999-01-14 03:48:04 Installed PostgreSQL