Thread: Exclusion constraint sql missing where clause

Exclusion constraint sql missing where clause

From

Adam Brusselback

Date:

29 November 2018, 01:46:22

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

Re: Exclusion constraint sql missing where clause

From

Akshay Joshi

Date:

29 November 2018, 08:09:57

Hi Adam

Please log this issue @ https://redmine.postgresql.org/projects/pgadmin4

On Thu, Nov 29, 2018 at 4:16 AM Adam Brusselback <adambrusselback@gmail.com> wrote:

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-9517
Mobile: +91 976-788-8246