I have the following in my configure file:
GREYLIST_TEST = SELECT CASE \
WHEN now() - block_expires > 0 THEN 2 \
ELSE 1\
END \
FROM relaytofrom \
WHERE relay_ip='${quote_pgsql:$sender_host_address}' \
AND from_domain='${quote_pgsql:$sender_address_domain}'
GREYLIST_ADD = INSERT INTO relaytofrom (relay_ip, from_domain) \
VALUES ( '${quote_pgsql:$sender_host_address}, \
'${quote_pgsql:$sender_address_domain}')
And the following acl_check_data entries:
# Greylist config
#
warn set acl_m7 = ${lookup pgsql{GREYLIST_TEST}{$value}{0}}
defer message = Temporary Local Error. Please try again later.
condition = ${if eq{$acl_m7}{0}{1}}
condition = ${lookup pgsql{GREYLIST_ADD}{yes}{no}}
defer condition = ${if eq{$acl_m7}{1}{1}}
The fails with the following error:
temporarily rejected after DATA: PGSQL: query failed: ERROR: syntax
error at or near "domain" at character 75
The @ character is messing this up. Anyone have an idea of why this is
happening?
Thanks in advance.
Jerry Wintrode