Announcement

Collapse
No announcement yet.

Import Data is not updating Sequence max value

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Import Data is not updating Sequence max value

    Hi,

    I'm using Navicat for postgreSQL 11.2.6 64 Bit non commercial.

    When i'm importing data (i tried by CSV or XLS or XLSX files) into a table having a sequence for an autoincrement field the current value is not uptaded if i'm importing this field.

    Is there a way to do that without changing the default value by hand in the sequence itself after the import?

    Thanks.


  • #2
    Would you please provide us the import file, the table sql (right-click your table and choose Dump SQL File > Structure Only) and screenshots showing the import wizard and the problem?

    You can send the information to our support center - https://help.navicat.com/hc/en-us

    Comment

    Working...
    X