citusdata / citusdata/citus

postgresql-10 IDENTITY vs SERIAL with citus

Open
#1,875 0 comments 0 reactions 0 assignees View on GitHub
sql
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

After reading https://blog.2ndquadrant.com/postgresql-10-identity-columns/ and wanting to use them in future work, are there any differences or limitations when using them with citus we should be aware of? Or might using them let citus support more operations? (I'm thinking of `INSERT INTO SELECT` not being able to support autogenerating ids).

I have a hunch the upgrade script they included in the blog post will need modifications to work with a distributed table, but perhaps not.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.