Discussion:
Exclusion constraint sql missing where clause
Adam Brusselback
2018-11-28 22:46:22 UTC
Permalink
Hey all,
Using pgadmin4 3.4 for Windows.
When looking at an exclusion constraint with a where clause in pgadmin4,
the where clause is missing from the SQL view. It almost caused me a major
headache when I was working on fixing an issue with that constraint, and I
dropped / replaced without the where clause.

Just wanted to give a heads up on that issue. If it's already been fixed in
a new version, sorry for the noise.

Thanks,
-Adam
Akshay Joshi
2018-11-29 05:09:57 UTC
Permalink
Hi Adam
Post by Adam Brusselback
Hey all,
Using pgadmin4 3.4 for Windows.
When looking at an exclusion constraint with a where clause in pgadmin4,
the where clause is missing from the SQL view. It almost caused me a major
headache when I was working on fixing an issue with that constraint, and I
dropped / replaced without the where clause.
Just wanted to give a heads up on that issue. If it's already been fixed
in a new version, sorry for the noise.
Thanks,
-Adam
--
*Akshay Joshi*

*Sr. Software Architect *



*Phone: +91 20-3058-9517Mobile: +91 976-788-8246*
Loading...