Ive change it to
headers_remove = ${if eq{${lookup pgsql \
{SELECT '1' FROM listman.lists \
WHERE \
listname = '${quote_pgsql:$local_part}' \
AND lists.options LIKE '%"reply-to-list"%' } \
}}{1} \
{Reply-to} \
{} \
}
trying things but still get:
╭considering:
${if░eq{${lookup░pgsql░{SELECT░'1'░FROM░░listman.lists░░WHERE░░listname░=░'${quote_pgsql^M
16:51:01.308 761879 ╭considering:
${lookup░pgsql░{SELECT░'1'░FROM░░listman.lists░░WHERE░░listname░=░'${quote_pgsql^M
16:51:01.308 761879 ╭considering:
SELECT░'1'░FROM░░listman.lists░░WHERE░░listname░=░'${quote_pgsql^M
16:51:01.308 761879 ├───────text:
SELECT░'1'░FROM░░listman.lists░░WHERE░░listname░=░'^M
16:51:01.308 761879 ├considering: ${quote_pgsql^M
16:51:01.308 761879 ├failed to expand: SELECT '1' FROM listman.lists WHERE
listname = '${quote_pgsql^M
16:51:01.308 761879 ╰───error message: "${quote_pgsql" is not a known
operator (or a } is missing in a variable reference)^M
16:51:01.308 761879 ├failed to expand: ${lookup pgsql {SELECT '1' FROM
listman.lists WHERE listname = '${quote_pgsql^M
16:51:01.308 761879 ╰───error message: "${quote_pgsql" is not a known
operator (or a } is missing in a variable reference)^M
16:51:01.308 761879 ├failed to expand: ${if eq{${lookup pgsql {SELECT '1' FROM
listman.lists WHERE listname = '${quote_pgsql^M
16:51:01.308 761879 ╰───error message: "${quote_pgsql" is not a known operator
(or a } is missing in a variable reference)^M
16:51:01.308 761879 message: lists_post router failed to expand
remove_headers item "${if eq{${lookup pgsql {SELECT '1' FROM listman.lists
WHERE listname = '${quote_pgsql": "${quote_pgsql" is not a known operator (or
a } is missing in a variable reference)^M
-----Original Message-----
From: Jeremy Harris via Exim-users <[email protected]>
Sent: Monday, May 26, 2025 4:21 PM
To: [email protected]
Subject: [exim] Re: Trying to add a reply-to header using pgsql lookup
CAUTION: External to USask. Verify sender and use caution with links and
attachments. Forward suspicious emails to [email protected]
On 2025/05/26 10:50 PM, Rowney, Dion via Exim-users wrote:
> 15:46:01.457 756913 ╰───error message: "${quote_pgsql" is not a known
> operator (or a } is missing in a variable reference)
> 15:46:01.457 756913 ├failed to expand: ${lookup pgsql {SELECT 'Reply-to' AS
> result FROM listman.lists WHERE lower(listname) = '${quote_pgsql
> 15:46:01.457 756913 ╰───error message: "${quote_pgsql" is not a known
> operator (or a } is missing in a variable reference)
> 15:46:01.457 756913 lists_post router: defer for [email protected]
> 15:46:01.457 756913 message: lists_post router failed to expand
> remove_headers item "${lookup pgsql {SELECT 'Reply-to' AS result FROM
> listman.lists WHERE lower(listname) = '${quote_pgsql": "${quote_pgsql" is
> not a known operator (or a } is missing in a variable reference)
> Thoughts?
The "failed to expand" shows the input has been truncated. What did the
matching "considering"
(further back) show?
Your "it works when" seems to have lost the FROM, so I have trouble trusting
it...
--
Cheers,
Jeremy
--
## subscription configuration (requires account):
## https://lists.exim.org/mailman3/postorius/lists/exim-users.lists.exim.org/
## unsubscribe (doesn't require an account):
## [email protected]
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
--
## subscription configuration (requires account):
## https://lists.exim.org/mailman3/postorius/lists/exim-users.lists.exim.org/
## unsubscribe (doesn't require an account):
## [email protected]
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
