Opened 15 years ago

Closed 15 years ago

#268 closed defect (duplicate)

[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 (1)

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

Download all attachments as: .zip

Change History (3)

Changed 15 years ago by erik@…

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

comment:1 Changed 15 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.

comment:2 Changed 15 years ago by dmorton

  • Resolution set to duplicate
  • Status changed from new to closed

superceded by #270

Note: See TracTickets for help on using tickets.