Changeset 4892 for trunk/include/dblayer/functions_pgsql.inc.php

Timestamp:

Feb 15, 2010, 8:49:04 PM (15 years ago)

Author:

nikrou

Message:

Feature 1255 :
update pwg_db_insert_id() function.
PosgreSQL needs table name to retrieve last insert auto increment id.

File:

• trunk/include/dblayer/functions_pgsql.inc.php (modified) (1 diff)

trunk/include/dblayer/functions_pgsql.inc.php

@@ -193 +193 @@
 }
 
-function pwg_db_insert_id()
-{
-  // select currval('piwigo_user_id_seq');
+function pwg_db_insert_id($table=null, $column='id')
+{
+  $sequence = sprintf('%s_%s_seq', strtolower($table), $column);
+  $query = '
+SELECT CURRVAL(\''.$sequence.'\');';
+
+  list($id) = pwg_db_fetch_row(pwg_query($query));
+
+  return $id;
 }