Ticket #268 (closed defect: duplicate)

Opened 3 years ago

Last modified 3 years ago

[PATCH] send-quarantine-digests.pl & Postgresql

Reported by: erik@… Owned by: rjl
Priority: normal Milestone:
Component: Perl scripts Version: 1.0.0
Severity: normal Keywords: digests, postgres, postgresql
Cc:

Description

send-quarantine-digests.pl uses 2 MySQL specific functions:

1) UNIX_TIMESTAMP(). Postgresql doesn't have a direct equivalent, but ROUND(DATE_PART('epoch', <value>)) is a close approximation.

2) DATE_ADD(). Postgresql doesn't need this, as the + operator will work on dates.

(patch to follow)

Attachments

maia-postgres-1.0.0.patch (2.3 kB) - added by erik@… 3 years ago.
patch send...digests.pl to check for Pg DSN, and DtRT in that case.

Change History

Changed 3 years ago by erik@…

patch send...digests.pl to check for Pg DSN, and DtRT in that case.

Changed 3 years ago by Ed <maia@…>

  • summary changed from send-quarantine-digests.pl & Postgresql to [PATCH] send-quarantine-digests.pl & Postgresql

Added [PATCH] to the summary line.

Changed 3 years ago by dmorton

  • status changed from new to closed
  • resolution set to duplicate

superceded by #270

Note: See TracTickets for help on using tickets.