On 1/17/18 23:57, Ashutosh Sharma wrote: > 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.
There is ALTER TABLE partitioned ADD EXCLUDE USING gist (a WITH &&); in alter_table.sql. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services