Skip to content

feat: Support DEFAULT NEXTVAL for Sequences #17616

@BohuTANG

Description

@BohuTANG

Summary

Add support for using sequences as DEFAULT values in table definitions:

CREATE SEQUENCE user_id_seq;

CREATE TABLE users (
  id INT DEFAULT NEXTVAL(user_id_seq),
  name VARCHAR
);

Current Workaround

Currently requires explicit NEXTVAL in every INSERT:

INSERT INTO users VALUES (NEXTVAL(user_id_seq), 'John');

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions