id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
17465	Multiple INSERT RETURNING	alexandr.s.rus@…	nobody	"Postgresql/oracle support multiple returning on insert request, django doesn't.

A have table


{{{
CREATE TABLE db_table (
    id integer NOT NULL,
    sid integer,
    oid integer NOT NULL,
    name1 character varying(250) NOT NULL,
    name1 text NOT NULL,
);

}}}

and want to execute query:


{{{
INSERT INTO db_table (name1, name2) values (""value1"", ""value2"") RETURNING id, sid, oid,
}}}

sid, oid values calculating by trigger before insert, and I need to use its after saving model.

Example of definition.


{{{
class DbTable(models.Model):
     oid = models.IntegerField(null=True, return=True)
     sid = models.IntegerField(null=True, return=True)
     name1 = modelsCharField(max_length=250)
     name2 = models.TextFiled()
}}}

or

{{{

class DbTable(models.Model):
     oid = models.IntegerField(null=True)
     sid = models.IntegerField(null=True)
     name1 = modelsCharField(max_length=250)
     name2 = models.TextFiled()

     class Meta:
         returning = ('oid', 'sid')


}}}

What do you think about whit feature?

"	New feature	closed	Database layer (models, ORM)	1.4-alpha-1	Normal	wontfix	db, orm, insert, django models		Unreviewed	0	0	0	0	0	0