Implement returning of auto id using RETURNING clause in PostgreSQL

Before we used a separate SELECT lastval() query which was both inefficient
and error-prone in cases where INSERT may cause triggers to override the
last value.

1 files changed, 12 insertions, 0 deletions

diff --git a/odb/relational/pgsql/source.cxx b/odb/relational/pgsql/source.cxx
index c17edc6..6bfa3d9 100644
--- a/odb/relational/pgsql/source.cxx
+++ b/odb/relational/pgsql/source.cxx
@@ -983,6 +983,18 @@ namespace relational
         }
 
         virtual void
+        persist_stmt_extra (type& c, relational::query_parameters&)
+        {
+          semantics::data_member* id (id_member (c));
+
+          if (id != 0 && id->count ("auto"))
+          {
+            os << endl
+               << strlit (" RETURNING " + column_qname (*id));
+          }
+        }
+
+        virtual void
         object_extra (type& c)
         {
           if (abstract (c))