PostgreSQL Partition and Unique Conflict
I am attempting to set up a database with partitions, however I am running into an error when creating the activity table. The 3 Table CREATEs (without the actual data) are as follows: CREATE TABLE collection ( id SERIAL PRIMARY KEY ); CREATE TABLE asset ( id SERIAL, collection_id INT, CONSTRAINT fk_collection FOREIGN KEY(collection_id) REFERENCES… Read More PostgreSQL Partition and Unique Conflict