[pgAdmin4][Patch]: RM_ 2620 - Getting error "Violates check constraint" while creating pgAgent job

[Surinder Kumar]

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
​

RM_2620.patch
Description: Binary data