[Phpgroupware-tracker] [bug #15588] get_last_insert_id broken for PostgreSQL 8.x

[Sigurd Nes]

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/