Question : Given the following code: CREATE SEQUENCE dbo.NextTestId AS [bigint] START WITH 10 INCREMENT BY 2 NO CACHE GO […]
Tag: sequence
Explicitly granting permissions to update the sequence for a serial column necessary?
Question : Recently I did create a table as a superuser including a serial id column, e.g., create table my_table […]
SQL Server 2008: sequence which restarts daily
Question : I have to add a trigger which should update a column using the following format strings: <current_date>_<per_day_incremental_id>, e.g […]
Postgres latest sequence id and uncommitted writes
Question : Hoping someone could clarify a section of this article “scalable-incremental-data-aggregation” and the corresponding question. Assume Postgres 10 and […]
INSERT INTO table FROM SELECT * with nextval() specification
Question : I need to copy records within the same table changing only one field. My table has default-generated sequence […]
What PostgreSQL query will return unused SEQUENCE #’s?
Question : I have enabled a UNIQUE key so PostgreSQL would act as a proof reader for duplicate entries as […]
What are the advantages of sequences in SQL Server 2012? [closed]
Question : It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or […]
I created a sequence but I can’t alter the increment number after that [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Why GRANT UPDATE on SEQUENCE in PostgreSQL
Question : I have seen postgresql allowing users to Grant update on a sequence. But never seen any update query […]
sp_sequence_get_range equivalent in Oracle
Question : Do we have sp_sequence_get_range equivalent in Oracle. I need to advance my sequence by some numbers always how […]