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.

[Patch] Correct index column order for PostgreSQL

#2400

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.

Reported by Michael Schuerig · April 2nd, 2009 @ 02:08 PM

State: duplicate
Milestone: 2.x
Assigned to: Tarmo Tänav Tarmo Tänav
Importance: none

Activity

  1. Max Lapshin
    Max Lapshin
    • Tag changed from 2.3.2, activerecord, active_record, postgresql to 2.3.2, activerecord, active_record, duplicate, postgresql

    April 20th, 2009 @ 05:38 PM

  2. Max Lapshin
    Max Lapshin
    • Assigned user set to Tarmo Tänav

    Tarmo, maybe close it as duplicate ticket?

    April 20th, 2009 @ 05:51 PM

  3. Tarmo Tänav
    Tarmo Tänav
    • State changed from new to duplicate

    April 20th, 2009 @ 10:07 PM