MIME-Version: 1.0
References: <387fa6c2-5de-f24-d522-46282597703@appl-ecosys.com>
 <CAKFQuwba=vb16vR47W0oo3SirkJ+UqLEg5j9-fqe+vm=0Q7_qw@mail.gmail.com>
 <1b139d9a-b95f-f7c8-52fb-9d7442c69ad9@appl-ecosys.com> <CAKFQuwY4PXdUYWxWzZ+idD64GLA2vrKf_UDcSPf=5VuYSDNRUA@mail.gmail.com>
 <97d69b9-48de-3bd4-95d-df5614ff44a@appl-ecosys.com> <4f319e27-0e54-40dd-888f-1e4c856a1b02@aklaver.com>
 <b6b331ff-913d-d5d8-905-aba54e90c99f@appl-ecosys.com>
In-Reply-To: <b6b331ff-913d-d5d8-905-aba54e90c99f@appl-ecosys.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Thu, 13 Jun 2024 15:29:01 -0700
Message-ID: <CAKFQuwY-E_EuCHO+Q1o2Lc1d0r-TUp9f18UWRx1TtMEsLzDHvA@mail.gmail.com>
Subject: Re: Reset sequence to current maximum value of rows
To: Rich Shepard <rshepard@appl-ecosys.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000d49e2c061acd084e"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwY-E_EuCHO%2BQ1o2Lc1d0r-TUp9f18UWRx1TtMEsLzDHvA%40mail.gmail.com>
Precedence: bulk

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

On Thu, Jun 13, 2024 at 3:13=E2=80=AFPM Rich Shepard <rshepard@appl-ecosys.=
com>
wrote:

> Yes, I'm sure. Early yesterday I did get duplicate key errors. That's whe=
n
> I
> looked on stackexchange to learn how to reset the sequence's max value to
> the value of the number of rows in the table. Not only did my attempt to
> add
> a single new company to the companies table change all company names in
> that
> one industry to the new name, but I just discovered that it changed all
> rows
> in that column to the new company name:
>
>
At present the belief there is a bug in PostgreSQL is unsubstantiated.

I suggest you look internally for how an update command that caused the
resultant data could have been executed.  That is much more plausible, and
thus a better use of time, if you want to spend more time on this, than
trying to produce the observed behavior again using just insert and
setval(...) commands.

David J.

--000000000000d49e2c061acd084e
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 Thu, Jun 13, 2024 at 3:13=E2=80=AFPM Rich Shepard &lt;<=
a href=3D"mailto:rshepard@appl-ecosys.com">rshepard@appl-ecosys.com</a>&gt;=
 wrote:</span><br></div></div><div class=3D"gmail_quote"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">Yes, I&#39;m sure. Early yesterday I did g=
et duplicate key errors. That&#39;s when I<br>
looked on stackexchange to learn how to reset the sequence&#39;s max value =
to<br>
the value of the number of rows in the table. Not only did my attempt to ad=
d<br>
a single new company to the companies table change all company names in tha=
t<br>
one industry to the new name, but I just discovered that it changed all row=
s<br>
in that column to the new company name:<br><br></blockquote><div><br></div>=
<div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-seri=
f">At present the belief there is a bug in PostgreSQL is unsubstantiated.</=
div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-=
serif"><br></div><div class=3D"gmail_default" style=3D"font-family:arial,he=
lvetica,sans-serif">I suggest you look internally for how an update command=
 that caused the resultant data could have been executed.=C2=A0 That is muc=
h more plausible, and thus a better use of time, if you want to spend more =
time on this, than trying to produce the observed behavior again using just=
 insert and setval(...) commands.</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>

--000000000000d49e2c061acd084e--