search

openplans / openblock

OpenBlock is a web application and RESTful service that allows users to browse and search their local area for "hyper-local news
61 stars 26 forks source link

Fix migration issue #289

Open bretwalker opened 11 years ago

bretwalker commented 11 years ago

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", ...

jheasly commented 10 years ago

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