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 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
- 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...