feeder: prevent reseting sequences to 0 (#31667)

This commit is contained in:
Benjamin Dauvergne 2019-03-30 20:19:34 +01:00
parent 25100cf7bd
commit 70a7271d15
1 changed files with 1 additions and 1 deletions

View File

@ -361,7 +361,7 @@ CREATE TABLE public.dates AS (SELECT
)
# Update sequence
self.ex("""SELECT setval(pg_get_serial_sequence('{name}', 'id'),
(SELECT MAX(id) FROM {name}))""", ctx={'name': name})
(SELECT GREATEST(1, MAX(id)) FROM {name}))""", ctx={'name': name})
def create_labeled_table(self, name, labels, comment=None):
self.create_table(