MIME-Version: 1.0
References: <0558ddd4d71641bdb41fa49b2425f73c@safrangroup.com>
 <A01D7215-2691-4FA6-8B79-E197B7DB9351@gmail.com> <98965993.3138805.1731699978332@mail.yahoo.com>
In-Reply-To: <98965993.3138805.1731699978332@mail.yahoo.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Fri, 15 Nov 2024 12:56:54 -0700
Message-ID: <CAKFQuwaPQBeFa==VJLYFYUh5V514Y4ZE9O0bz+kmLjgowLm9kQ@mail.gmail.com>
Subject: Re: Need exact SQL query to find List of Detach Partitioned Tables
 (Yet to be Dropped)
To: Bharani SV-forum <esteembsv-forum@yahoo.com>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000001fd5c60626f8facc"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwaPQBeFa%3D%3DVJLYFYUh5V514Y4ZE9O0bz%2BkmLjgowLm9kQ%40mail.gmail.com>
Precedence: bulk

--0000000000001fd5c60626f8facc
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Nov 15, 2024 at 12:46=E2=80=AFPM Bharani SV-forum <esteembsv-forum@=
yahoo.com>
wrote:

> Need exact SQL query to find List of Detach Partitioned Tables (Yet to be
> Dropped)
>
>
The premise that a detached table is distinguishable from any other table
that is not a partition is an interesting one that I wouldn't necessarily
expect to be determinable.  You could probably write a query listing tables
that are candidates for attaching to an existing partitioned table and then
filter out those that are actually attached.

David J.

--0000000000001fd5c60626f8facc
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Fri, Nov 15, 2024 at 12:46=E2=80=AFPM Bharani SV-forum =
&lt;<a href=3D"mailto:esteembsv-forum@yahoo.com">esteembsv-forum@yahoo.com<=
/a>&gt; wrote:</span></div></div><div class=3D"gmail_quote"><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid =
rgb(204,204,204);padding-left:1ex"><div style=3D"font-family:&quot;Helvetic=
a Neue&quot;,Helvetica,Arial,sans-serif;font-size:16px" dir=3D"ltr"><div></=
div></div><div style=3D"font-family:&quot;Helvetica Neue&quot;,Helvetica,Ar=
ial,sans-serif;font-size:16px" dir=3D"ltr">Need exact SQL query to find Lis=
t of Detach Partitioned Tables (Yet to be Dropped)</div><div style=3D"font-=
family:&quot;Helvetica Neue&quot;,Helvetica,Arial,sans-serif;font-size:16px=
" dir=3D"ltr"><br></div></blockquote><div><br></div><div class=3D"gmail_def=
ault" style=3D"font-family:arial,helvetica,sans-serif">The premise that a d=
etached table is distinguishable from any other table that is not a partiti=
on is an interesting one that I wouldn&#39;t necessarily expect to be deter=
minable.=C2=A0 You could probably write a query listing tables that are can=
didates for attaching to an existing partitioned table and then filter out =
those that are actually attached.</div><div class=3D"gmail_default" style=
=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_d=
efault" style=3D"font-family:arial,helvetica,sans-serif">David J.</div><div=
 class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><=
br></div></div></div>

--0000000000001fd5c60626f8facc--