public inbox for [email protected]  

help / color / mirror / Atom feed

From: Rich Shepard <[email protected]>
To: [email protected]
Subject: Re: Reset sequence to current maximum value of rows [RESOLVED]
Date: Thu, 13 Jun 2024 13:22:09 -0700 (PDT)
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKFQuwb-msDns_5FNvpakoW1GNksejZPApMw05eNQtuwnQiMYw@mail.gmail.com>
References: <[email protected]>
	<CAKFQuwba=vb16vR47W0oo3SirkJ+UqLEg5j9-fqe+vm=0Q7_qw@mail.gmail.com>
	<[email protected]>
	<CAKFQuwY4PXdUYWxWzZ+idD64GLA2vrKf_UDcSPf=5VuYSDNRUA@mail.gmail.com>
	<[email protected]>
	<CAKFQuwb-msDns_5FNvpakoW1GNksejZPApMw05eNQtuwnQiMYw@mail.gmail.com>

On Thu, 13 Jun 2024, David G. Johnston wrote:

> There is no way, in the absence of a user trigger, that the above insert
> command changed pre-existing rows. And if you cannot reproduce the
> behavior you claim to have seen I will continue to just assume you have
> faulty memory.

David,

While there might be no way that what happened could happen, did happen.

You're welcome to your opinion about my memory yet my eyes saw the results
of the select statement.

Regardless, I updated all of yesterday's company insertions so they're now
all correct (again.) Found another one I missed then and successfully
inserted it without specifying the PK field or its DEFAULT value as I
learned from Ron's reply.

Regards,

Rich

view thread (10+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Reset sequence to current maximum value of rows [RESOLVED]
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox