Postgres Pro
Downloads
Home   >   mailing lists

[pgAdmin4][Patch]: RM_ 2620 - Getting error "Violates checkconstraint" while creating pgAgent job - Mailing list pgadmin-hackers

From Surinder Kumar
Subject [pgAdmin4][Patch]: RM_ 2620 - Getting error "Violates checkconstraint" while creating pgAgent job
Date
Msg-id CAM5-9D8v9Ue6ahx5MrqS4YGEXTA2eGeq07FiXaFERefSraE-BQ@mail.gmail.com
Whole thread Raw
Responses Re: [pgAdmin4][Patch]: RM_ 2620 - Getting error "Violates checkconstraint" while creating pgAgent job  (Akshay Joshi <akshay.joshi@enterprisedb.com>)
List pgadmin-hackers
Tree view

Hi

It gives error because database value is passed in query generated when jobstep > kind == 'batch'.
the database value must be ‘’, if jobstep > kind == 'batch' as per check constraint:

"pga_jobstep_check1" CHECK (jstdbname <> ''::name AND jstkind = 's'::bpchar OR jstdbname = ''::name AND (jstkind = 'b'::bpchar OR jstconnstr <> ''
::text))

Please find attached patch and review.

Thanks,
Surinder

​
Attachment

pgadmin-hackers by date:

Previous
From: Murtuza Zabuawala
Date:
Subject: [pgAdmin4][Patch]: To fix Function/Procedures messages issue in query tool
Next
From: Harshal Dhumal
Date:
Subject: [pgAdmin4][RM2586] Cleanup feature test