[Evergreen-dev] Evergreen 3.14 - Remove support for PostgreSQL 10 (and 11 and 12) ?

[Blake Graham-Henderson]

All,

I ran into an issue installing Evergreen today. It turned out to be an 
issue with a feature merged onto the main branch. The breaking code:

....
CREATE OR REPLACE FUNCTION evergreen.redact_value(
     input_data      anycompatible,
     skip_redaction  BOOLEAN         DEFAULT FALSE,
     redact_with     anycompatible   DEFAULT NULL
) RETURNS anycompatible AS $f$
....

The error that is generated:

psql:reporter-schema.sql:579: ERROR:  type anycompatible does not exist

I brought it up on IRC 
<http://irc.evergreen-ils.org/evergreen/2024-09-20#i_561373>

"anycompatible" doesn't appear to be supported until Postgres 13.

https://www.postgresql.org/docs/13/datatype-pseudo.html

Just throwing the issue out there to the larger group.

I'm all for removing PG[10,11,12] support starting with Evergreen 3.14. 
But there might be a way to continue to support the older versions with 
some tweaks to our install process and/or SQL code.

-- 
-Blake-
Conducting Magic
Will consume any data format
MOBIUS
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-dev/attachments/20240920/80dbd53b/attachment.htm>