openblock icon indicating copy to clipboard operation
openblock copied to clipboard

Fix migration issue

Open bretwalker opened this issue 13 years ago • 1 comments

I got an error when running my initial migrations. One of the migrations didn't have an order_by that Postgres wanted.

This change fixes this error:

Error in migration: db:0026_make_unique_lookup_names DatabaseError: SELECT DISTINCT ON expressions must match initial ORDER BY expressions LINE 1: SELECT DISTINCT ON ("db_lookup"."name") "db_lookup"."name", ...

bretwalker avatar Feb 03 '13 04:02 bretwalker

Same issue. This worked for me! (Would be nice to see it pulled in!)

jheasly avatar Oct 04 '13 02:10 jheasly