On Nov 10, 2008, at 8:37 AM, paftek wrote:
>
> Hi,
>
> I am using SQLAlchemy with PostgreSQL 8.3.
> Today I just discovered the great "postgres_returning" functionnality.
>
> Dumb question :
> Is it possible to take advantage of it in session mode ? In other
> words, is it possible for session.add() to issue only one "INSERT
> INTO ... RETURNING ..." query instead of two ("INSERT" then "SELECT"),
> like in the following example :
this is an enhancement that we'll be pursuing in the near future.
Jason was having problems getting INSERT RETURNING to work at all with
pg 8.3 the other day for some reason.
the exact functionality will be that the PG dialect uses INSERT
RETURNING by default in all cases where right now it executes a
sequence beforehand. This means that if you issue an insert() using
PG, no explicitness will be needed in order to get new defaults or
primary key values back. A dialect flag
"use_returing_on_inserts=True" will allow control over the feature at
the configurational level. The ORM wont be aware of it explicitly.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
