|
From: SourceForge.net <no...@so...> - 2013-01-18 19:27:20
|
Patches item #3601405, was opened at 2013-01-18 10:39 Message generated for change (Comment added) made by phd You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540674&aid=3601405&group_id=74338 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Ken Lalonde (kenlalonde) >Assigned to: Oleg Broytman (phd) Summary: Use "insert ... returning id" with postgres Initial Comment: When inserting records with driver postgres, it's faster to use the single statement "INSERT ... RETURNING id", rather than 2 statements -- one to get the current sequence value (and increment it), and another to do the insert. Patch is against SQLObject-1.2.4/sqlobject/postgres/pgconnection.py. ---------------------------------------------------------------------- >Comment By: Oleg Broytman (phd) Date: 2013-01-18 11:27 Message: Good idea, thanks! Will test it. It's a major change (SQLObject currently supports Postgres back to 8.1 while INSERT/RETURNING requires at least 8.2) so I can only apply it to the trunk. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540674&aid=3601405&group_id=74338 |
