search

timescale / timescaledb

An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
https://www.timescale.com/
Other
16.8k stars 852 forks source link

Allow hypertable constraint creation USING INDEX #7040

Open arajkumar opened 1 week ago

arajkumar commented 1 week ago

Prior to this commit, we disallow the following

CREATE UNIQUE INDEX foo_pkey ON foo USING btree(id, time);
ALTER TABLE foo ADD CONSTRAINT foo_pkey
PRIMARY KEY USING INDEX foo_pkey;
svenklemm commented 1 week ago

Hmm ideally we remove the pg constraint tracking from chunk_constraint then we wouldnt need to do anything special for constraint creation with index.

nikkhils commented 4 hours ago

A lot of tests are failing.