Issue 138: Patch: postgresql compatibility
Status:  WontFix
Owner: ----
Closed:  Jan 2009
Reported by kar...@gmail.com, Oct 9, 2008
Attached patch (against trunk) fixes all postgresql issues found by the
tests in 1.0a6, while all tests in 1.0a6 still pass in a mysql db.

However, some tests in trunk don't pass (but are not related to the database).

Changed are:
* index names in db/schema.rb
* some mysql-specific SQL constructs (but I tried to keep the mysql
optimizations I didn't understood)
* a number of datatype related queries (using the boolean type in PG)

This also fixes  issue #135  (db:bootstrap not working for Postgres).



substruct_pg.patch
48.9 KB   View   Download
Oct 9, 2008
#1 kar...@gmail.com
Sorry, it's issue #132, not #135.

Oct 10, 2008
#2 rogerpack2005
I assume it still works with mysql?
Oct 10, 2008
#3 kar...@gmail.com
Applied against 1.0a6, all (including a few added) but one tests are OK with both
mysql and PG.
Applied against trunk, five or six tests fail for both databases (but the same tests
fail with an unpatched trunk).
I have not tried much of the application against the MySQL DB.

Nov 2, 2008
Project Member #4 subim...@gmail.com
Please apply against newest trunk. All tests are passing here. Should pass with your patch as well. Resubmit after 
testing against current trunk circa r160.

I don't have time to debug your patches!
Jan 24, 2009
Project Member #5 subim...@gmail.com
Marking this as "wontfix" until I get a working, tested patch. Sorry.
Status: WontFix