
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
-
Sam Smoot October 22nd, 2007 @ 04:48 PM
- State changed from open to invalid
No longer applicable.
-
Dan Kubb (dkubb) April 9th, 2011 @ 01:56 AM
- State changed from invalid to resolved
- Milestone order changed from 0 to 0
(from [3983f4ae28b65f2f4b7a5f26e69971dac24d165a]) Allow Set objects to be passed to the :set option of a within validator.
Fixes #11.
https://github.com/datamapper/dm-validations/commit/3983f4ae28b65f2...
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.
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
- Nobody is watching this ticket.
Referenced by
-
11 PostgreSQLAdapter INSERT should use RETURNING syntax Fixes #11. https://github.com/datamapper/dm-validations/c...
-
10 Fix Sqlite3Adapter Fixes #10, #11 https://github.com/datamapper/do/commit/35...