2009/10/20 Alban Hertroys <dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>: > You miss a keyword in your query in renameTable; it should be " RENAME TO ", > not " TO ". Thanks for spotting that. I've made my amendments for next submit. > Wouldn't it be convenient to have an EXPLAIN ANALYSE version of explain()? > Maybe with a boolean parameter? The problem is, I don't see where they're using this function, so if they're using it to EXPLAIN an INSERT, UPDATE or DELETE statement, ANALYZE would execute it... unless I roll it back straight after. > In insertObject() you have a query "SELECT $keyName AS 'id' FROM $table'" - > That line contains two syntax errors: 'id' (You probably meant "id") and > $table' (spurious trailing quote). Again, you're right and well spotted. :) Fixed both of those. Cheers for helping out Alban! :D Thom -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
