Georg Boegerl is looking for a recommendation on handling automatically incremented IDs in RisingWave similar to the 'series' datatype in Postgres. He needs a unique record ID to delete duplicates and prefers database management over application level. He also mentions the challenge of migrating legacy data from Postgres and ingesting it without duplicates. Tianxiao Shen mentions internally generated primary keys in RisingWave and suggests using them for deduplication. Georg Boegerl asks how to take advantage of these internally generated primary keys in a SQL statement.
Georg Boegerl
Asked on Jan 09, 2024
select __row__id, v from t;