Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

This project is archived and is in readonly mode.

Postgres 8.3.6: base_test: test_quote fails due to not quoting escape characters

#2410

<"\ \001 ' \n \n ""> expected but was <" \001 ' \n \n "">.

edge rails... gem: postgres (0.7.9.2008.01.28) PostgreSQL 8.3.6 ubuntu 8.04

I have the DBs 'activerecord_unittest' and 'activerecord_unittest2' created in a UTF8 database in PostgreSQL. The 'rails' user has superuser rights to the DBs.

ActiveRecord::Base.configurations = { 'arunit' => {

 :adapter  => 'postgresql',
 :username => 'rails',
 :password => 'rails',
 :database => 'activerecord_unittest',
 :min_messages => 'warning',
 :encoding => 'unicode',
 :host =>  'localhost'

}, 'arunit2' => {

 :adapter  => 'postgresql',
 :username => 'rails',
 :password => 'rails',
 :database => 'activerecord_unittest2',
 :min_messages => 'warning',
 :encoding => 'unicode',
 :host =>  'localhost'

} }

I have tried setting the encoding to utf8 with the same results.

jrafaniello@jrafaniello-laptop:~/src/rails/activerecord$ rake test_postgresql TEST=./test/cases/base_test.rb 2>&1> base_test.log

See attached log file.

Reported by Joe Rafaniello · April 3rd, 2009 @ 06:23 PM

State: resolved
Milestone: 3.x
Assigned to: Tarmo Tänav Tarmo Tänav
Importance: none

Activity

  1. Joe Rafaniello
    Joe Rafaniello

    This has been fixed in the proposed patch in ticket 2412 which addes Postgres support for standard_conforming_strings = on.

    April 3rd, 2009 @ 09:20 PM

  2. Joe Rafaniello
    Joe Rafaniello

    This ticket can be closed since 2412 will address the issue raised here.

    January 27th, 2010 @ 04:25 PM

  3. Jeremy Kemper
    Jeremy Kemper
    • Milestone changed from 2.x to 3.x

    May 4th, 2010 @ 06:48 PM

  4. Rohit Arondekar
    Rohit Arondekar
    • State changed from new to resolved

    Ticket 2412 has been marked duplicate, while the original ticket #1837 PostgresSQLAdapter#unescape_bytea does not handle "\\" has been resolved with commits and the message "Reopen with a failing test case if you have any issues."

    Also since the original poster has said this ticket can be closed, I'll close it as resolved.

    June 15th, 2010 @ 10:56 AM