|
From: | Sigurd Nes |
Subject: | [Phpgroupware-tracker] [bug #15588] get_last_insert_id broken for PostgreSQL 8.x |
Date: | Tue, 31 Jan 2006 10:06:39 +0000 |
User-agent: | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5 |
URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=15588> Summary: get_last_insert_id broken for PostgreSQL 8.x Project: phpGroupWare Submitted by: sigurdne Submitted on: Tue 01/31/06 at 10:06 Category: API - phpGWapi Item Group: 0.9.16.010 Severity: 4 - Important Priority: 5 - Normal Status: None Privacy: Public Assigned to: skwashd Open/Closed: Open Component Version: None Platform Version: None Reproducibility: None Planned Release: None Fixed Release: _______________________________________________________ Details: The OID field is not be present by default in PostgreSQL 8.1 and therefore the get_last_insert_id in class.db_pgsql.inc.php that relays on pg_last_oid() won't work. There is a mention of a function lastval() to retrieve the last inserted sequence - but I think this is a new function. One might have to check for the pgsql version - and then apply the appropiate method. Or - it might be sufficient to ask for the max value of the field in question? Anyone care to fix this? Regards Sigurd _______________________________________________________ Reply to this item at: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=15588> _______________________________________________ Message sent via/by Savannah http://savannah.gnu.org/
[Prev in Thread] | Current Thread | [Next in Thread] |