Top "Database-sequence" questions

How to reset postgres' primary key sequence when it falls out of sync?

I ran into the problem that my primary key sequence is not in sync with my table rows. That is, …

postgresql primary-key database-sequence

Postgres manually alter sequence

I'm trying to set a sequence to a specific value. SELECT setval('payments_id_seq'), 21, true This gives an error: …

postgresql database-sequence

Db2: How to update the current value of a sequence

We use a sequence in a Db2 database. Recently, we have migrated the data from an AIX server to a …

sql db2 sequences database-sequence

Sequences not affected by transactions?

I have a table create table testtable( testtable_rid serial not null, data integer not null, constraint pk_testtable primary …

postgresql transactions rollback database-sequence

Sequence does not exist when it does - Postgres/Spring Boot

I am writing a Spring Boot web-app and using a Postgres db to persist my data. I created a table …

postgresql hibernate spring-data database-sequence

Why is an integer variable not accepted as a value for START WITH in sequence

I am trying to create dynamic start number for sequence but it is not accepting variable viz. @START_SEQ for …

sql-server tsql database-sequence