On Thu, Jan 18, 2018 at 12:00 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Ashutosh Sharma <ashu.coe...@gmail.com> writes: >> While working on exclusion constraints for one of our internal >> project, I noticed that there is no test-case for exclusion >> constraints in alter_table.sql file. However, for other constraints i >> could see lots of test-cases in alter_table.sql. There are hardly 1-2 >> test-cases for exclusion constraint using ALTER TABLE command (1 in >> constraints.source and 1 for partitioned table in alter_table.sql). >> Shouldn't we consider adding few test-cases for exclusion constraints >> in alter_table.sql considering that we have added lots of test-cases >> for other constraints in this file. Thoughts? > > They're tested elsewhere, so this proposal seems rather duplicative. >
By elsewhere do you mean in the contrib module 'sepgsql' (sepgsql/sql/ddl.sql) because other than that i didn't find any other places having ALTER TABLE ... ADD CONSTRAINT ... EXCLUDE ... sort of sql queries other than the files which i mentioned in my earlier email. Thanks. -- With Regards, Ashutosh Sharma EnterpriseDB:http://www.enterprisedb.com