Skip site navigation (1) Skip section navigation (2)

Re: When inserting '\' the insert fails.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mips(at)mips(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: When inserting '\' the insert fails.
Date: 2001-07-21 22:18:27
Message-ID: 24542.995753907@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
pgsql-bugs(at)postgresql(dot)org writes:
> When inserting  '\' the insert fails.

Your examples work fine for me:

regression=# create table t3 (tt text, date timestamp);
CREATE
regression=# INSERT INTO t3 ( tt,date )
regression-# VALUES ( 'aaaaaaa ''\\'' bbbbbbbb','2000-10-30 21:18:05' );
INSERT 5814810 1
regression=# INSERT INTO t3 ( tt,date )
regression-# VALUES ( 'eqwehqw ''\\'' dsdsa','2000-10-30') ;
INSERT 5814811 1
regression=# select * from t3;
          tt          |          date
----------------------+------------------------
 aaaaaaa '\' bbbbbbbb | 2000-10-30 21:18:05-05
 eqwehqw '\' dsdsa    | 2000-10-30 00:00:00-05
(2 rows)

I suspect the problem is somewhere in your application code.  You might
try turning on query logging at the postmaster to see what's actually
being transmitted to the backend by the application.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: eCommerce Software Solutions Inc.Date: 2001-07-22 04:15:45
Subject: Leaking Handles in Postgres 7.1.2 on Cygwin dll 1.3.2 on Win 2000
Previous:From: pgsql-bugsDate: 2001-07-21 21:01:02
Subject: When inserting '\' the insert fails.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group