Re: DecodeShortURL fails with postgresql

2023-01-29 Thread John Hardin
On Sun, 29 Jan 2023, Benny Pedersen wrote: Jan 29 01:02:00 localhost postgres[15177]: [11-3] DELETE FROM short_url_cache Jan 29 01:02:00 localhost postgres[15177]: [11-4] WHERE short_url $1 = AND created < CAST(EXTRACT(epoch FROM NOW()) AS INT) - 86400 Jan 29 05:40:

Re: DecodeShortURL fails with postgresql

2023-01-28 Thread Benny Pedersen
Sidney Markowitz skrev den 2023-01-25 22:04: Benny Pedersen wrote on 19/01/23 10:47 +13:00: https://github.com/apache/spamassassin/blob/trunk/lib/Mail/SpamAssassin/Plugin/DecodeShortURLs.pm#L594-L601 only me testing postgresql ? As I discovered from a recently discovered postgres-only bug, t

Re: DecodeShortURL fails with postgresql

2023-01-25 Thread Sidney Markowitz
Benny Pedersen wrote on 19/01/23 10:47 +13:00: https://github.com/apache/spamassassin/blob/trunk/lib/Mail/SpamAssassin/Plugin/DecodeShortURLs.pm#L594-L601 only me testing postgresql ? As I discovered from a recently discovered postgres-only bug, there must not have been much use of postgres

Re: DecodeShortURL fails with postgresql

2023-01-18 Thread Benny Pedersen
Martin Gregorie skrev den 2023-01-19 00:45: On Wed, 2023-01-18 at 22:47 +0100, Benny Pedersen wrote: https://github.com/apache/spamassassin/blob/trunk/lib/Mail/SpamAssassin/Plugin/DecodeShortURLs.pm#L594-L601 only me testing postgresql ? I'm using it with a self-written Perl data retrieval

Re: DecodeShortURL fails with postgresql

2023-01-18 Thread Martin Gregorie
On Wed, 2023-01-18 at 22:47 +0100, Benny Pedersen wrote: > > https://github.com/apache/spamassassin/blob/trunk/lib/Mail/SpamAssassin/Plugin/DecodeShortURLs.pm#L594-L601 > > only me testing postgresql ? > > I'm using it with a self-written Perl data retrieval module that was tested long ago, so

DecodeShortURL fails with postgresql

2023-01-18 Thread Benny Pedersen
https://github.com/apache/spamassassin/blob/trunk/lib/Mail/SpamAssassin/Plugin/DecodeShortURLs.pm#L594-L601 only me testing postgresql ?