[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: alter function/procedure depends on extension
From:       "David G. Johnston" <david.g.johnston () gmail ! com>
Date:       2022-02-19 5:08:55
Message-ID: CAKFQuwZy1Ui6EpsA2kfesiahjAidVqi4i5zHxGAatuXa3acCCQ () mail ! gmail ! com
[Download RAW message or body]

On Fri, Feb 18, 2022 at 6:16 PM Bryn Llewellyn <bryn@yugabyte.com> wrote:

>
> (4) The clue to the whole thing is the semantics of the LoV for
> "pg_depend. deptype" (see below) — but you all kept this a secret from me!
>

I didn't even think to look at the system catalogs for guidance in this
kind of thing.  The catalogs are not what I consider end-user facing
documentation; I'd want the core documentation (SQL Command Reference and
exposition chapters for different features) to be sufficient for someone to
understand how these things work.  Now, I would probably have been a bit
less certain of myself had I gone and looked at the catalogs early on.
Seeing the specification for DEPENDENCY_AUTO (a) would have reset my
internal consistency trigger.


> David wrote:
>
> This must be a typo: "depends on" and "is dependent upon" mean the same.
> I'm guessing that this was meant:  « An extension neither depends on nor is
> *depended* upon by its members.  » If so, then it's wrong. Yes: an extension
> doesn't depend on its members. This query (which runs without error) shows
> that an extension depends upon only the schema nominated by
> "create extension… with schema…".
>

> But no: the objects do depend upon the extension that creates them, as
> this query shows:
>
>
Yeah, I seem to have had a brain fade there.
David J.

[Attachment #3 (text/html)]

<div dir="ltr"><div dir="ltr"><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><span \
style="font-family:Arial,Helvetica,sans-serif">On Fri, Feb 18, 2022 at 6:16 PM Bryn \
Llewellyn &lt;<a href="mailto:bryn@yugabyte.com">bryn@yugabyte.com</a>&gt; \
wrote:</span><br></div></div><div class="gmail_quote"><blockquote class="gmail_quote" \
style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div style="overflow-wrap: \
break-word;"><div><br></div><div>(4) The clue to the whole thing is the semantics of \
the LoV for &quot;pg_depend. deptype&quot; (see below) — but you all kept this a \
secret from me!<br></div></div></blockquote><div><br></div><div>I didn&#39;t even \
think to look at <span class="gmail_default" \
style="font-family:arial,helvetica,sans-serif">the system catalogs  </span>for \
guidance<span class="gmail_default" style="font-family:arial,helvetica,sans-serif"> \
in this kind of thing</span>.   The catalogs are not what I consider end-user facing \
documentation; I&#39;d want the core documentation (SQL Command Reference and \
exposition chapters for different features) to be sufficient for someone to \
understand how these things work.   Now, I would probably have been a bit less \
certain of myself had I gone and looked <span class="gmail_default" \
style="font-family:arial,helvetica,sans-serif">at the catalogs  </span>early on.<span \
class="gmail_default" style="font-family:arial,helvetica,sans-serif">   Seeing the \
specification for DEPENDENCY_AUTO (a) would have reset my internal consistency \
trigger.</span></div><div><br></div><blockquote class="gmail_quote" style="margin:0px \
0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div \
style="overflow-wrap: break-word;"><div><br>David wrote:<br><br>This must be a typo: \
&quot;depends on&quot; and &quot;is dependent upon&quot; mean the same. I'm guessing \
that this was meant:  « An extension  neither depends on nor is *depended* upon by \
its members.  » If so, then it's wrong. Yes: an extension doesn't depend on its  \
members. This query (which runs without error) shows that an extension depends upon \
only the schema nominated by &quot;create  extension… with \
schema…&quot;.</div></div></blockquote><blockquote class="gmail_quote" \
style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div style="overflow-wrap: \
break-word;"><div><br>But no: the objects do depend upon the extension that creates \
them, as this query shows:<div><br></div></div></div></blockquote><div><br></div><div \
class="gmail_default" style="font-family:arial,helvetica,sans-serif">Yeah, I seem to \
have had a brain fade there.</div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"></div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif">David J.</div><div \
class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><br></div></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]