#11 ✓resolved
Sam Smoot

PostgreSQLAdapter INSERT should use RETURNING syntax

Reported by Sam Smoot | October 6th, 2007 @ 10:57 AM

Instead of a separate query after INSERT to retrieve the auto-increment identity, (which isn't safe for concurrency), we should use the RETURNING syntax in PostgreSQLAdapter:

INSERT INTO "zoos" ("name", "notes") VALUES ('Bob', 'Moo') RETURNING "id"

This should be safer, and probably faster as well.

Comments and changes to this ticket

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

People watching this ticket

Referenced by