RE: [Phpgroupware-developers] get_last_insert_id broken for PostgreSQL 8.x

[Sigurd Nes]

I have posted a patch - please have a look at it
http://savannah.gnu.org/bugs/download.php?item_id=15588&item_file_id=3346

Regards

Sigurd

> From: Sigurd Nes address@hidden
> Sent: 2006-01-31 10:58:59 CET
> To: address@hidden
> Subject: [Phpgroupware-developers] get_last_insert_id broken for PostgreSQL 
> 8.x
> 
> 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