Postgre-Compatibility #218

Closed
masche842 opened this Issue Apr 2, 2012 · 4 comments

Comments

Projects
None yet
3 participants
Contributor

masche842 commented Apr 2, 2012

... i.e. for Heroku.

Element-List can't be rendered:
Error: PG::Error: ERROR: syntax error at or near "." LINE 1: ...my_elements"."page_id" = 3 AND (alchemy_elements.page_id... ^ : SELECT "alchemy_elements".* FROM "alchemy_elements" WHERE "alchemy_elements"."page_id" = 3 AND (alchemy_elements.page_id IS NOT NULL) ORDER BY position

I'll see what I can do

masche842 was assigned Apr 2, 2012

Owner

tvdeyen commented Apr 2, 2012

I wanted to implement postgresql testing on travis. Maybe now is a good time to do this then ;)

http://about.travis-ci.org/docs/user/database-setup/

... i.e. for Heroku.

Element-List can't be rendered:
Error: PG::Error: ERROR: syntax error at or near "." LINE 1: ...my_elements"."page_id" = 3 AND (alchemy_elements.page_id... ^ : SELECT "alchemy_elements".* FROM "alchemy_elements" WHERE "alchemy_elements"."page_id" = 3 AND (alchemy_elements.page_id IS NOT NULL) ORDER BY position

I'll see what I can do


Reply to this email directly or view it on GitHub:
magiclabs#218

Owner

tvdeyen commented Apr 5, 2012

Just found this in the spree initializers:

LIKE = ActiveRecord::Base.connection.adapter_name == 'PostgreSQL' ? 'ILIKE' : 'LIKE'
Owner

robinboening commented Apr 8, 2012

explanation to ilike (no, its not from apple, nor from facebook ;-))
http://solaimurugan.blogspot.de/2010/07/ilike-operator-in-postgresql.html

Owner

tvdeyen commented Apr 26, 2012

Should be done

tvdeyen closed this Apr 26, 2012

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment