Opened 7 years ago

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

Change History (1)

comment:1 by Kris Deugau, 7 years ago

Resolution: → duplicate
Status: new → closed

Resolving; duplicate #59 expresses the task much better

Note: See TracTickets for help on using tickets.