Joe Rafaniello's profile

Joe Rafaniello commented at 8:06 PM
Good point... maybe others know when exactly Postgres started complaining about implicit type conversions. Currently, I'm adding the USING CAST for 8.0 and high...
Joe Rafaniello commented at 7:27 PM
To make the unit test pass, attached is a simple patch based on John Whitley's suggestion of "USING CAST" which was introduced in 8.0. This was needed because 8...
- Title changed from ActiveRecord 2.1.1 breaks formerly legit postgres migrations to [Patch] ActiveRecord 2.1.1 breaks formerly legit postgres migrations
by Joe Rafaniello at 7:16 PM
Attached is the unit test diff which fails on Edge rails with 8.3.6 PG

Joe Rafaniello commented at 9:20 PM
This has been fixed in the proposed patch in ticket 2412 which addes Postgres support for standard_conforming_strings = on.
Joe Rafaniello created the ticket at 6:23 PM

<"\ \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 'activerec...

Joe Rafaniello commented at 9:18 PM
The patch addresses the following errors in the attached AR unit test log:

1) Failure: test_quote(BasicsTest)
```
[./test/cases/base_test.rb:1478:in `test_quote'
 ...
```
Joe Rafaniello created the ticket at 9:13 PM

Many ActiveRecord PG unit tests failed on PG 8.3.6 if standard_conforming_strings was set to "on"

E should only be prefixed for standard_conforming_strings = of...

Joe Rafaniello commented at 5:50 PM

Looks like the diff did not print properly... see the attached migration_test.rb, method: test_change_column_requires_type_cast

I updated the one in test/cases/...
Joe Rafaniello commented at 5:33 PM
Sorry, the unit test did not get attached... let's try that again.
Joe Rafaniello commented at 5:32 PM

I have recreated it with he gem: postgres (0.7.9.2008.01.28) and have PostgreSQL 8.3.6 installed on ubuntu 8.04.

I have uploaded the AR/test/cases/migration_tes...