public inbox for [email protected]
help / color / mirror / Atom feedFrom: Edward J. Sabol <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: Re: pg_upgrade failure due to dependencies
Date: Tue, 1 Jul 2025 07:10:36 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
--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 <[email protected]>=
; 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" </span><span>style for SQL functions, where the function body is j=
ust a string. If they had used the standard </span><span>conformi=
ng new style, PostgreSQL would try to trach dependencies. Not sure if t=
hat would have been </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 <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 <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--
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: pg_upgrade failure due to dependencies
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox