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

When inserting '\' the insert fails.

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: When inserting '\' the insert fails.
Date: 2001-07-21 21:01:02
Message-ID: 200107212101.f6LL12v56768@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Kristian Knudsen (mips(at)mips(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
When inserting  '\' the insert fails.

Long Description
When inserting  '\' to a text field and there is a date column
the insert fails.
But only if the date insert contains time information also.
Look at the code examples below.
where 1) fails because of the time 21:18:05
2) is inserted ok because I omit the time info.
I am using pg 7.1 on red hat 6.2 and try to port an web-application
from ms-SqlServer 7.0 to pg and apache.
And I want to transfer all existing data to pg.

Kristian Knudsen - MIPS Denmark Develuping Center

Sample Code
1)
INSERT INTO t3 ( tt,date )
VALUES ( 'aaaaaaa ''\\'' bbbbbbbb','2000-10-30 21:18:05' )
Error: ERROR: Bad timestamp external representation '2000-10-30 21NULLNULL' 

2)
INSERT INTO t3 ( tt,date )
VALUES ( 'eqwehqw ''\\'' dsdsa','2000-10-30') 

No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-07-21 22:18:27
Subject: Re: When inserting '\' the insert fails.
Previous:From: Darko PrenosilDate: 2001-07-21 19:56:19
Subject: Re: WIN32 Non Blocking

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