search

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.43k stars 638 forks source link

Syntax Error displayed when user try to create new Schedule and select start date and time in Exception section (RM #3638) #2068

Closed dpage closed 2 years ago

dpage commented 6 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/3638 Originally created by Fahar Abbas at 2018-09-12 07:27:30 UTC.

Tested Platform: Windows 2012 R2 64 MAC OS 10.13

Build:

https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2018-09-11/

Steps

  1. Install pg-10
  2. install pgagent through stackbuilder
  3. Launch pgAdmin4
  4. Right Click on New job and provide name and click Save Button
  5. Job created successfully.
  6. Expand job and click on create new Schedule
  7. provide name
  8. provide start date in General tab
  9. Click on Exception tab
  10. Select date and Time
  11. Click on Save Button

ERROR: syntax error at or near "INSERT" LINE 20: INSERT INTO pgagent.pga_exception ( ^

dpage commented 6 years ago

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/3259 Originally created by Fahar Abbas at 2018-09-12 07:27:23 UTC.

2.png

Filename: 2.png

dpage commented 6 years ago

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/3260 Originally created by Fahar Abbas at 2018-09-12 07:27:26 UTC.

3.png

Filename: 3.png

dpage commented 6 years ago

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/3261 Originally created by Fahar Abbas at 2018-09-12 07:27:26 UTC.

1.png

Filename: 1.png

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3638#note-4 Originally created by Akshay Joshi at 2018-09-14 10:20:11 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed Ready
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3638#note-5 Originally created by Akshay Joshi at 2018-10-09 06:18:48 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed New In Progress
Assigned To changed Akshay Joshi
Sprint changed Ready EDB Sprint 24
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3638#note-6 Originally created by Khushboo Vashi at 2018-10-10 09:33:37 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed EDB Sprint 24 EDB Sprint 25
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3638#note-7 Originally created by Akshay Joshi at 2018-10-12 11:27:43 UTC.

Patch Sent: https://www.postgresql.org/message-id/CANxoLDdFHqKPeWeheqfCW2ysbZE_CzELkZ0fOi+QoAmBgYY7EQ@mail.gmail.com

dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3638#note-8 Originally created by Dave Page at 2018-10-17 11:26:23 UTC.

Redmine ticket header update:

Name Old Value New Value
Fixed Version changed 3.5
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3638#note-9 Originally created by Akshay Joshi at 2018-10-17 11:28:36 UTC.

Applied in changeset commit:50738db2b8c871869a37c0b7617687bd4efd9da3.

Redmine ticket header update:

Name Old Value New Value
Status changed In Progress In Testing
Done Ratio changed 0 90
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3638#note-10 Originally created by Fahar Abbas at 2018-10-22 09:44:53 UTC.

Tested Build:

https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2018-10-22/

Tested on MAC 10.12 and Windows 2012 R2 64

Redmine ticket header update:

Name Old Value New Value
Status changed In Testing Resolved
Done Ratio changed 90 100
dpage commented 2 years ago

Issue closed on Redmine.