| 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: | Whole Thread | Raw Message | 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.
--------------------------------------------------------------------------
| 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 |