[SQL-CVS] [ sqlobject-Patches-3601405 ] Use "insert ... returning id" with postgres

[SourceForge.net <no...@so...>]

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