This project is archived and is in readonly mode.
[Patch] Correct index column order for PostgreSQL
Reported by Michael Schuerig | April 2nd, 2009 @ 02:08 PM | in 2.x
The query used to determine indexes from the database in the ActiveRecord PostgreSQL adapter returns columns in arbitrary order. As a result, in schema.rb multi-column indexes are likely to be created with columns in the wrong order.
The attached patch apparently fixes this problem. However, I don't understand the PostgreSQL-specifics, but rather got the code by asking on comp.databases.postgresql.
Comments and changes to this ticket
-
Max Lapshin April 20th, 2009 @ 05:38 PM
- Tag changed from “2.3.2, activerecord, active_record, postgresql” to “2.3.2, activerecord, active_record, duplicate, postgresql”
-
Max Lapshin April 20th, 2009 @ 05:51 PM
- Assigned user set to “Tarmo Tänav”
Tarmo, maybe close it as duplicate ticket?
-
Tarmo Tänav April 20th, 2009 @ 10:07 PM
- State changed from “new” to “duplicate”
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
<h2 style="font-size: 14px">Tickets have moved to Github</h2>
The new ticket tracker is available at <a href="https://github.com/rails/rails/issues">https://github.com/rails/rails/issues</a>
People watching this ticket
Michael Schuerig
Tarmo Tänav
Attachments
Referenced by
-
2515
db:schema:dump with PostgreSQLAdapter dumps multiple column indexes in undefined order
Please consider using the patch I attached to #2400. I
do...