>> The problem is the SQL query generated by the select code above is not FOR >> SHARE, it's FOR UPDATE: >> >> SELECT search_terms.term_id, search_terms.term >> FROM search_terms >> WHERE search_terms.lock = :lock_1 AND search_terms.status = :status_1 >> ORDER BY search_terms.term >> LIMIT :param_1 FOR UPDATE
particularly suspicious is that the paramstyle above, known as "named" (i.e. :param), is not the paramstyle used by the current Postgresql DBAPIs - psycopg2 uses %(pyformat)s and pg8000 defaults to "format". this suggests the above is just the result of saying "print statement". What do you see actually being sent to the database ? -- You received this message because you are subscribed to the Google Groups "sqlalchemy" 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/sqlalchemy?hl=en.
