Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sHqSf-00BADn-2Y for pgsql-general@arkaria.postgresql.org; Thu, 13 Jun 2024 19:50:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sHqSc-006fY6-Oi for pgsql-general@arkaria.postgresql.org; Thu, 13 Jun 2024 19:50:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sHqSc-006fXo-Dx for pgsql-general@lists.postgresql.org; Thu, 13 Jun 2024 19:50:15 +0000 Received: from mail.appl-ecosys.com ([50.126.108.78]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sHqSW-001AbE-Oj for pgsql-general@lists.postgresql.org; Thu, 13 Jun 2024 19:50:14 +0000 Received: from salmo.appl-ecosys.com (salmo.appl-ecosys.com [192.168.55.1]) by mail.appl-ecosys.com (Postfix) with ESMTP id 62CA42A2B7C for ; Thu, 13 Jun 2024 12:50:07 -0700 (PDT) Date: Thu, 13 Jun 2024 12:50:07 -0700 (PDT) From: Rich Shepard To: "pgsql-generallists.postgresql.org" Subject: Re: Reset sequence to current maximum value of rows In-Reply-To: <0f40b8e8-a4a1-4c9b-9c90-7402e9edb628@aklaver.com> Message-ID: <828cb6d2-bc1-f370-9e49-6b5be418d683@appl-ecosys.com> References: <387fa6c2-5de-f24-d522-46282597703@appl-ecosys.com> <0f40b8e8-a4a1-4c9b-9c90-7402e9edb628@aklaver.com> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 13 Jun 2024, Adrian Klaver wrote: > You sure you did not actually do an UPDATE without a WHERE? Adrian, Yep. There was no row to update as I was adding a new company. Regards, Rich