5 Replies Latest reply on Jun 12, 2018 10:40 AM by Steven Hawkins

    TEIID 30357 nextval does not exist

    Chandra M Newbie



      How to insert data to postgres table which has primary key column with sequence associated ?


      VDB is dynamic created out of native model of postgres database. Trying to insert via http post method by passing information in the body.


      Postgres table has a id column with serial data type (which auto creates sequence and associate nextval(sequence) to the id column).


      Tried inserting with or without id column, throws "TEIID 30357 nextval does not exist" error.


      Was able to insert data, when sequence is removed from id column. This is to check whether http post method was able to insert and it does.


      But need to work with sequence applied? Any pointers?