ROWIDs

When creating a table, Informix® automatically adds a ROWID integer column (applies to non-fragmented tables only). The ROWID column is auto-filled with a unique number and can be used like a primary key to access a given row.

When the feature is enabled, PostgreSQL tables are automatically created with a OID column (Object Identifier) of type INTEGER. The behavior is equivalent to Informix ROWID columns (see Solution).

Solution

The database automatically converts ROWID keywords to OID for PostgreSQL. You can execute "SELECT ROWID FROM" and "UPDATE .. WHERE ROWID = ?" statements as with Informix.

Note:
  • Starting with PostgreSQL version 8.1, OIDs are no longer supported by default. You need to define the default_with_oid parameter in postgresql.conf to get OID columns created for tables. See Database configuration and design tasks.
  • SQLCA.SQLERRD[6]is not supported. All references to SQLCA.SQLERRD[6] must be removed because this variable will not hold the ROWID of the last INSERTed or UPDATEd row when using the PostgreSQL interface.