can you post the code that generates the error and the query generated bu
the DAL ( i.e. print db(......)._select() with the underscore) ?
On Saturday, April 13, 2013 4:28:55 PM UTC+2, Ricardo Cárdenas wrote:
>
> Just upgraded to 2.4.6-stable+timestamp.2013.04.12.23.32.51.
>
> Code that worked in my prior version (I think trunk 2013.04.02? sorry
> don't have the exact version on-hand) now breaks. I get the following error:
>
> <class 'psycopg2.ProgrammingError'> function replace(integer, unknown,
> unknown) does not exist LINE 1: ...ost.groups AS CHAR(512)) LIKE (('%|' ||
> (REPLACE((REPLACE(me... ^ HINT: No function matches the given name and
> argument types. You might need to add explicit type casts
>
> The ticket comes from a 3-table query on PostgreSQL that uses .CONTAINS.
> (Perhaps related to this
> issue<https://groups.google.com/forum/?fromgroups=#!searchin/web2py/contains/web2py/WKmzK6prO20/SRkZ2SF5YlwJ>.)
>
> When I simplify the query to a simple db(table).select(), the code works
> (though of course it doesn't bring back the results I am looking for).
>
> I just thought I'd throw it out there in case someone has worked on that
> code recently..
>
> best regards -Ricardo
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
