0 Replies Latest reply: Nov 28, 2011 4:02 PM by Sanjay Bharatiya RSS

    DB Adapter - PostgreSQL - Primary key - auto increment handling

    Sanjay Bharatiya

      I have to connect to a PostgreSQL DB. I have a table in which has a primary key called seq_id. This seq_id is being incremented using a sequence.
      I have to configure the DB adapter for this table. The problem is that while creating the adapter it does not allow me to deselect the primary key (seq_id). Because of this I have to supply a value for the seq_id while inseting the data using the adapter. But this defeats the purpose of sequence (auto increment).

      Is there a way to get around this and to avoid specifying the value for seq_id while using the DB Adapter and let it get inserted using the sequence of the DB?