MIME-Version: 1.0
In-Reply-To: <CAD=mzVW0A-TeX2Pce2N+7xQGy3hEi2xfUntH007MQ0TY=cVRkw@mail.gmail.com>
References: <CAD=mzVUGj2Zg0RY9YJwgDzAeghPjuT0FOnNs-aysTBGss87Yyw@mail.gmail.com>
 <f519a562-667c-4a96-9844-a2aaa42928b3@aklaver.com> <CAD=mzVUS8mFK42zmVUUC3JkiN=9QSUZ_Qxayd6=KJwbqdd0HzA@mail.gmail.com>
 <CANzqJaBAOzCjXaBFLa6cYweVNf5LbBvLYFkWx_hb3YezOP3quw@mail.gmail.com>
 <CAD=mzVXK+4tLMbENMecruPbk8cmeE4smD=ENUrwx5wh4N7hZhA@mail.gmail.com>
 <acc8b587497a65d38fafe4e0030e252eda78398f.camel@cybertec.at>
 <20240713220545.cgjghaggksov3xkt@hjp.at> <f70b1f5c575497a615c797588964d3c21823ef7e.camel@cybertec.at>
 <20240715142744.7e7a3wtdfxinochf@hjp.at> <CAD=mzVW9d0cPfccGVHLvCkcq4Mc-Wg5La3+XAHHEY1AMeOQ_Bw@mail.gmail.com>
 <20240716003731.m75sye7qq74wadhe@hjp.at> <CAD=mzVVTE1Jx0fpsQ=OVW0CL5LiGg_RHA4kq+cbPqTShA5EwVw@mail.gmail.com>
 <CAKFQuwZL8jWOX35fSRsMp2tjfGpqsnUgG=cCKuVBen5PC8Jddg@mail.gmail.com>
 <CAKFQuwaHzz-BYGn7N4AMZ8QWy072eqMC-WQRwUFNNuOQeE19oQ@mail.gmail.com> <CAD=mzVW0A-TeX2Pce2N+7xQGy3hEi2xfUntH007MQ0TY=cVRkw@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Mon, 15 Jul 2024 22:42:14 -0700
Message-ID: <CAKFQuwYu3TMd6Fum51JOTHDXUt_V3BHobz2VnVkpe9QLnjYYgA@mail.gmail.com>
Subject: Re: Dropping column from big table
To: sud <suds1434@gmail.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>, 
	"Peter J. Holzer" <hjp-pgsql@hjp.at>
Content-Type: multipart/alternative; boundary="000000000000deccc1061d56ceed"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwYu3TMd6Fum51JOTHDXUt_V3BHobz2VnVkpe9QLnjYYgA%40mail.gmail.com>
Precedence: bulk

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

On Monday, July 15, 2024, sud <suds1434@gmail.com> wrote:

>
> Thank you for the confirmation.
> And if someone wants to fully remove that column from the table , then th=
e
> only option is to create a new table with an exact set of active columns
> and insert the data into that from the existing/old table and then rename
> it back to old. Is this correct understanding?
>

You haven=E2=80=99t removed the column from the table, you=E2=80=99ve remov=
ed the whole
dang table while creating a new, wholly unrelated, one that just happens to
have the same name.  But the name of a table isn=E2=80=99t its primary key,=
 though
some places do use it for lookup purposes.

David J.

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

On Monday, July 15, 2024, sud &lt;<a href=3D"mailto:suds1434@gmail.com">sud=
s1434@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail_quote" style=
=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=
=3D"ltr"><div dir=3D"ltr"><br></div><div class=3D"gmail_quote"><div dir=3D"=
ltr" class=3D"gmail_attr">Thank you for the confirmation.=C2=A0<br></div><d=
iv>And if someone wants to fully remove that column from the table , then t=
he only option is to create a new table with an exact set of active columns=
 and insert the data into that from the existing/old table and then rename =
it back to old. Is this correct understanding?</div></div></div></blockquot=
e><div><br></div><div>You haven=E2=80=99t removed the column from the table=
, you=E2=80=99ve removed the whole dang table while creating a new, wholly =
unrelated, one that just happens to have the same name.=C2=A0 But the name =
of a table isn=E2=80=99t its primary key, though some places do use it for =
lookup purposes.</div><div><br></div><div>David J.</div><div><br></div>

--000000000000deccc1061d56ceed--