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/
_______________________________________________
Phpgroupware-tracker mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/phpgroupware-tracker
