When inserting '\' the insert fails.
От | pgsql-bugs@postgresql.org |
---|---|
Тема | When inserting '\' the insert fails. |
Дата | |
Msg-id | 200107212101.f6LL12v56768@hub.org обсуждение исходный текст |
Ответы |
Re: When inserting '\' the insert fails.
|
Список | pgsql-bugs |
Kristian Knudsen (mips@mips.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
В списке pgsql-bugs по дате отправления: