Re: Trying to add a reply-to header using pgsql lookup

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/