Content-Type: multipart/alternative;
 boundary=Apple-Mail-C392753E-6901-47A6-8C77-42658DE87293
Content-Transfer-Encoding: 7bit
From: "Edward J. Sabol" <edwardjsabol@gmail.com>
Mime-Version: 1.0 (1.0)
Subject: Re: pg_upgrade failure due to dependencies
Message-Id: <D305115C-0461-4F41-89EB-3BFCC11C240A@gmail.com>
References: <396f2fb636248f329c152c6eca189f4348fec726.camel@cybertec.at>
In-Reply-To: <396f2fb636248f329c152c6eca189f4348fec726.camel@cybertec.at>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Date: Tue, 1 Jul 2025 07:10:36 -0400
Archived-At: 
 <https://www.postgresql.org/message-id/D305115C-0461-4F41-89EB-3BFCC11C240A%40gmail.com>
Precedence: bulk


--Apple-Mail-C392753E-6901-47A6-8C77-42658DE87293
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto"><div dir=3D"ltr"></div><div dir=3D"ltr">On J=
ul 1, 2025, at 5:37=E2=80=AFAM, Laurenz Albe &lt;laurenz.albe@cybertec.at&gt=
; wrote:</div><blockquote type=3D"cite"><div dir=3D"ltr"><span>Moreover, Pos=
tgreSQL cannot check dependencies, since the function was defined using the "=
old"&nbsp;</span><span>style for SQL functions, where the function body is j=
ust a string. &nbsp;If they had used the standard&nbsp;</span><span>conformi=
ng new style, PostgreSQL would try to trach dependencies. &nbsp;Not sure if t=
hat would have been&nbsp;</span><span>enough to avoid the problem, but clear=
ly better.</span><br><span></span></div></blockquote><br><div>Just for my ed=
ification, how would one create that PostGIS function using the "standard-co=
nforming new style"?</div><div><br></div><div>*All* of the examples in Postg=
eSQL's current documentation are the "old" (string) style at&nbsp;<a href=3D=
"https://www.postgresql.org/docs/current/xfunc-sql.html">https://www.postgre=
sql.org/docs/18/xfunc-sql.html</a>.</div><div><div style=3D"display: block;"=
 class=3D""><br></div><div style=3D"display: block;" class=3D"">The only exa=
mple of the new style in the PostgreSQL documentation that I could find is t=
he very trivial second example at&nbsp;<a href=3D"https://www.postgresql.org=
/docs/current/sql-createfunction.html">https://www.postgresql.org/docs/18/sq=
l-createfunction.html</a>. The other examples on that web page are all the o=
ld style.</div></div><div style=3D"display: block;" class=3D""><br></div><di=
v>If the new style is better, perhaps someone should update the PostgreSQL d=
ocumentation to use it more than just once. More complicated examples of "ne=
w style" SQL functions are needed, I feel.</div><div><br></div><div>My web s=
earches for more information on "standard-conforming new style" SQL function=
s were not fruitful. All I kept finding were examples of the "old" kind in t=
he first 3 pages of my search results. Any pointers to useful web pages cove=
ring this topic in some detail would be appreciated.</div><div><br></div><di=
v>Thanks,</div><div>Ed</div><div><br></div></body></html>=

--Apple-Mail-C392753E-6901-47A6-8C77-42658DE87293--