<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">So here's what happened: When I added the new trigger for LP 2023314 I used the Pg11+ FOR EACH ROW EXECUTE FUNCTION syntax rather than the pg <= 10 FOR EACH ROW EXECUTE PROCEDURE so creating a db on pg10 will fail for all releases from yesterday, 3.10.4, 3.11.2, and 3.12.0, and main. <div><br></div><div>ALL POINT RELEASE UPGRADES WILL ALSO FAIL ON PG 10.</div><div><br></div><div>Until the last point release of the last branch that supports Postgres 10 we need to continue to use the EXECUTE PROCEDURE syntax. As Postgres is slow to *remove* syntax support this will likely continue to work for a very long time. (Both syntaxes are still supported in pg 15 and current.)</div><div><br></div><div>Since we have the branches for the point releases I'll correct them and rebuild the tarballs because we support pg10 even in main, so this needs to work everywhere.</div><div><br></div><div>Jason</div><div><div>
<meta charset="UTF-8"><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div><br>-- <br>Jason Boyer<br>Senior System Administrator<br>Equinox Open Library Initiative<br>JBoyer@equinoxOLI.org<br>+1 (877) Open-ILS (673-6457)<br>https://equinoxOLI.org/</div></div></div></div>
</div>
<div><br><blockquote type="cite"><div>On Dec 14, 2023, at 12:56 PM, Jason Boyer <JBoyer@equinoxOLI.org> wrote:</div><br class="Apple-interchange-newline"><div><meta http-equiv="content-type" content="text/html; charset=utf-8"><div style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">Ah, what combination was broken wasn't entirely clear. I'll check on rel_3_10 and pg 10 because I believe it's supported there so it needs to work.<div><br></div><div>Jason<br id="lineBreakAtBeginningOfMessage"><div>
<meta charset="UTF-8"><div dir="auto" style="caret-color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div dir="auto" style="caret-color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div dir="auto" style="caret-color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div><br>-- <br>Jason Boyer<br>Senior System Administrator<br>Equinox Open Library Initiative<br>JBoyer@equinoxOLI.org<br>+1 (877) Open-ILS (673-6457)<br>https://equinoxOLI.org/</div></div></div></div>
</div>
<div><br><blockquote type="cite"><div>On Dec 14, 2023, at 12:42 PM, Blake Graham-Henderson <blake@mobiusconsortium.org> wrote:</div><br class="Apple-interchange-newline"><div>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<div>
Jason,<br>
<br>
Thanks for taking a look! A couple of clarifications:<br>
<br>
- It's rel_3_11<br>
- My test machine used PG 10:<br>
<br>
make -f Open-ILS/src/extras/Makefile.install
postgres-server-ubuntu-focal-10<br>
<br>
Could be something going on in my environment. If you've tested it
and it's working for you then I'm sure I've got something amiss over
here.<br>
<pre class="moz-signature" cols="72">-Blake-
Conducting Magic
Will consume any data format
MOBIUS
</pre>
<div class="moz-cite-prefix">On 12/14/2023 11:32 AM, Jason Boyer
wrote:<br>
</div>
<blockquote type="cite" cite="mid:769A6F0B-A0B0-4E27-801D-BA47A57B0247@equinoxOLI.org">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
Galen and I have done a little research on this and it looks like
the rel_3_10 branch can't be used to setup a new database on
Postgres 15. Just going back to pg 14 a new db + concerto works
just fine. Since no one is expected to install a fresh 3.10 system
on pg15 this is fine.
<div><br>
</div>
<div>Jason<br id="lineBreakAtBeginningOfMessage">
<div>
<meta charset="UTF-8">
<div dir="auto" style="caret-color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div dir="auto" style="caret-color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div dir="auto" style="caret-color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div><br>
-- <br>
Jason Boyer<br>
Senior System Administrator<br>
Equinox Open Library Initiative<br>
<a class="moz-txt-link-abbreviated" href="mailto:JBoyer@equinoxOLI.org">JBoyer@equinoxOLI.org</a><br>
+1 (877) Open-ILS (673-6457)<br>
<a class="moz-txt-link-freetext" href="https://equinoxoli.org/">https://equinoxOLI.org/</a></div>
</div>
</div>
</div>
</div>
<div><br>
<blockquote type="cite">
<div>On Dec 14, 2023, at 9:37 AM, Blake Graham-Henderson via
Evergreen-dev <a class="moz-txt-link-rfc2396E" href="mailto:evergreen-dev@list.evergreen-ils.org"><evergreen-dev@list.evergreen-ils.org></a>
wrote:</div>
<br class="Apple-interchange-newline">
<div>
<div>Jason,<br>
<br>
I created the tarball, tested it, and uploaded it to the
site. I also updated the downloads page. Maybe that was
a bit hasty. I'll revert that if needs be. One thing
that was concerning was the installation of the concerto
set threw this error:<br>
<br>
psql:assets_concerto.sql:58: ERROR: update or delete
on table "record_entry" violates foreign key constraint
"browse_entry_def_map_source_fkey" on table
"browse_entry_def_map"<br>
<br>
-Blake-<br>
Conducting Magic<br>
Will consume any data format<br>
MOBIUS<br>
573-234-4513<br>
877-312-3517<br>
<br>
On 12/14/2023 7:15 AM, Jason Stephenson via
Evergreen-dev wrote:<br>
<blockquote type="cite">Hi, all.<br>
<br>
I'm going to release 3.10.4 sometime today or
tomorrow. I've got personal stuff to do, and I'm
working on a summary of the release discussion. It's a
lot of information to digest and summarize.<br>
<br>
Blake, are you ready to release 3.11.2?<br>
<br>
I'm not hanging out in IRC today, but I might pop in
tomorrow. I have less going on then.<br>
<br>
Jason Stephenson<br>
_______________________________________________<br>
Evergreen-dev mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:Evergreen-dev@list.evergreen-ils.org">Evergreen-dev@list.evergreen-ils.org</a><br>
<a class="moz-txt-link-freetext" href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev</a><br>
</blockquote>
<br>
_______________________________________________<br>
Evergreen-dev mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:Evergreen-dev@list.evergreen-ils.org">Evergreen-dev@list.evergreen-ils.org</a><br>
<a class="moz-txt-link-freetext" href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev</a><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</div>
</div></blockquote></div><br></div></div></div></blockquote></div><br></div></body></html>