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

From: Surinder Kumar <surinder(dot)kumar(at)enterprisedb(dot)com>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: [pgAdmin4][Patch]: RM_ 2620 - Getting error "Violates check constraint" while creating pgAgent job
Date: 2017-08-02 12:37:24
Message-ID: CAM5-9D8v9Ue6ahx5MrqS4YGEXTA2eGeq07FiXaFERefSraE-BQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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 Content-Type Size
RM_2620.patch application/octet-stream 1.1 KB

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Harshal Dhumal 2017-08-02 13:32:01 [pgAdmin4][RM2586] Cleanup feature test
Previous Message Murtuza Zabuawala 2017-08-02 10:40:25 [pgAdmin4][Patch]: To fix Function/Procedures messages issue in query tool