amavisd-new with postgresql help

[Christoph Moench-Tegeder]

## Benny Pedersen (me at junc.eu):

> $sql_select_white_black_list = 'SELECT wb FROM wblist,mailaddr WHERE
> (wblist.rid=?) AND (wblist.sid=mailaddr.id) AND (mailaddr.email IN
> (%k)) ORDER BY mailaddr.priority DESC';

> Jun 14 21:46:02 localhost postgres[22001]: [7-1] 2023-06-14
> 19:46:02.275 UTC [22001] ERROR:  operator does not exist: bytea =
> character varying at character 88

So that's a datatype mismatch.
Short answer: README_FILES/README.sql-pg and RELEASE_NOTES (ok,
at line 6416).

> Jun 14 21:46:02 localhost postgres[22001]: [7-2] 2023-06-14
> 19:46:02.275 UTC [22001] HINT:  No operator matches the given name and
> argument types. You might need to add explicit type casts.
> Jun 14 21:46:02 localhost postgres[22001]: [7-3] 2023-06-14
> 19:46:02.275 UTC [22001] STATEMENT:  SELECT *,users.id FROM
> users,policy WHERE (users.policy_id=policy.id) AND (users.email IN
> ($1,$2,$3,$4,$5,$6)) ORDER BY users.priority DESC

And there's the statement for that - it's $sql_select_white_black_list.
Counting characters, it's the "users.email IN (...)" part.
And given that bytea is not a preferred type, that has to come from
somewhere, and from the order of operands I believe it's the query, so
I think you set "$sql_allow_8bit_address = 1" (that is not the
default!) which forces the %k expansion to be passed as a bytea
parameter, but you left the table at the "legacy" form with the
text datatype for column email.

You should make sure that your configuration (sql_allow_8bit_address)
matches your database.

Regards,
Christoph

-- 
Spare Space