PostgreSQL Update Self-Grocence

-- Updating the automation sequence often requires Used


select setval('dm_table_column_id_seq',(select max(id) from dm_table_column));


select setval('dm_table_id_seq',(select max(id) from dm_table));


select setval('dm_database_id_seq',(select max(id) from dm_database));

-- Update automation sequence, which is often used


select setval('dm_table_column_id_seq',(select max(id) from dm_table_column));


select setval('dm_table_id_seq',(select max(id) from dm_table));


select setval('dm_database_id_seq',(select max(id) from dm_database));

< /p>

Leave a Comment

Your email address will not be published.