Opened 8 years ago
Closed 8 years ago
#58 closed task (duplicate)
Start using "RETURNING" for DB IDs of things just added
| Reported by: | Kris Deugau | Owned by: | |
|---|---|---|---|
| Priority: | minor | Milestone: | |
| Version: | Keywords: | ||
| Cc: | 
Description
Currently several bits do "INSERT blah blah blah", then "SELECT currval(sequence)" to retrieve the ID of the thing just inserted for further work.
These constructs should be switched to "INSERT blah blah blah RETURNING idfield" instead, where supported by DBI.
  Note:
 See   TracTickets
 for help on using tickets.
    ![[ DeepNet IP Database ]](/images/ipdb-logo.png)

Resolving; duplicate #59 expresses the task much better