feeder: prevent reseting sequences to 0 (#31667)
This commit is contained in:
parent
25100cf7bd
commit
70a7271d15
|
@ -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(
|
||||
|
|
Loading…
Reference in New Issue