postgresql-10 IDENTITY vs SERIAL with citus
Open
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
Assessment
This issue has not been assessed yet.