From e9ececbb1e1fabf5ec4794c07ceacc5577597fef Mon Sep 17 00:00:00 2001 From: paca70 Date: Sun, 27 Apr 2003 16:03:01 +0000 Subject: [PATCH] $db->Insert_ID seems to work with postgresql too --- lib/datalib.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/lib/datalib.php b/lib/datalib.php index a7955c8a81..7e8bf3bc76 100644 --- a/lib/datalib.php +++ b/lib/datalib.php @@ -618,10 +618,11 @@ function insert_record($table, $dataobject, $returnid=true) { } if ($returnid) { - if ($CFG->dbtype == "mysql") { + if ($CFG->dbtype == "mysql" || $CFG->dbtype == "postgres7") { return $db->Insert_ID(); // ADOdb has stored the ID for us, but it isn't reliable } + // Try to pull the record out again to find the id. This is the most cross-platform method. if ($rs = $db->Execute("SELECT id FROM $CFG->prefix$table WHERE $select")) { if ($rs->RecordCount() == 1) { -- 2.39.5