El Friday 06 February 2009 10:07:20 johnnybutler7 escribió:
> Hi,
>
> My search works fine locally, i am searching numerous field types,
> string, double, date etc...
>
> config.search.columns = [:name, :score, :created_at]
>
> When i search the above locally it works fine but whn i deploy to live
> and search i get the following error below.  Why is this behaving
> different in production?  I am using postgres for both development and
> production and the same version of AS????
>
> ActiveRecord::StatementInvalid (PGError: ERROR:  function lower(double
> precision) does not exist
> LINE 1: ...'™ÿ™uiko%' OR LOWER(sites.name) LIKE E'uiko%' OR LOWER
> (surv...
>                                                              ^
> HINT:  No function matches the given name and argument types. You
> might need to add explicit type casts.
>
> Anybody know why??

do you have the same version of postgres in both servers?


-- 
Sergio Cambra .:: entreCables S.L. ::.
Nicolás Guillén 6, locales 2 y 3. 50.018 Zaragoza
T) 902 021 404 F) 976 52 98 07 E) [email protected]

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"ActiveScaffold : Ruby on Rails plugin" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/activescaffold?hl=en
-~----------~----~----~----~------~----~------~--~---

  • Se... johnnybutler7
    • ... Sergio Cambra .:: entreCables - Symbol Servicios Informáticos S.L. ::.
      • ... johnnybutler7
        • ... Kenny Ortmann

Reply via email to