Qt4 QPSQL QSqlQuery::lastInsertId oid problem

My application use different database drivers, to connect. And i want to use one code for different database (now i am testing Oracel OCI and PSQL). And i have troubles with psql driver:

After insert query, i use QSqlQuery::lastInsertId() method to get id of inserted row. LastInsertId return oid value, not id, that i am waiting. I use additional query (something like sequence::cur_val) or make query like "SELECT id FROM table_name WHERE oid= lastInsertId". But, this is crutches around psql driver lastInsertId. How i can get actually id of row? It is not good, when in code i use

Code:

---

if (psql_driver)  { get_real_id_from_oid(table_name, oid) }

---

.

I found in qt4.6.3 psql driver sources such code for lastInsertId:

Code:

---

QVariant QPSQLResult::lastInsertId() const
{
    if (isActive()) {
        Oid id = PQoidValue(d->result);
        if (id != InvalidOid)
            return QVariant(id);
    }
    return QVariant();
}

---

Maybe it is usefull to make additional query in psql driver and return realyId or make additional method?!?

for testing i use such table:

Code:

---

CREATE TABLE test (
  id oid NOT NULL DEFAULT nextval('test_autoin_sequence'::regclass),
  "name" text
)
WITH (
  OIDS=TRUE
);

---

sequence create:

Code:

---

CREATE SEQUENCE test_autoin_sequence
  INCREMENT 1
  MINVALUE 1
  MAXVALUE 9223372036854775807
  START 31
  CACHE 1;

---

thanks

For pgsql insert query with returning clause:
INSERT INTO tbl1(col1,col2) VALUES (DEFAULT, 'adsf') RETURNING col1; -- or RETURNING * for all columns
After that:
QSqlQuery::next();
And read returning values (for examle, generated by sequence)
May be oracle have same mechanism.

Thank you for your help, i will try your advice for oracle, postgres and for mysql. If it works (or not) i will write reply