public inbox for [email protected]  

help / color / mirror / Atom feed

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

On Thu, Jun 13, 2024 at 11:24 AM Rich Shepard <[email protected]>
wrote:

> On Thu, 13 Jun 2024, David G. Johnston wrote:
>
> > You need to show your work here.  As your PK is a number it cannot have a
> > company name as a value and so this doesn't make sense.
>
> insert into companies (company_nbr,company_name,industry,status) values
> (DEFAULT,'new company name','Industry','Opportunity')
>
> With DEFAULT as the company_nbr why can't the company_name not have a
> value?
>

Because you specified company_name in the column listing for the things you
are inserting values for.  So in column position 2 you must have a value
than can be inserted into the company_name column.  It is utterly
immaterial how you specified the value for column position 1.


> > If you use the default when inserting the next value in the sequence is
> > used.
>
> Yes, that's the theory. It didn't work for me and why it didn't is what I
> want to understand.
>
>
We can't help you understand if you don't show a complete working example
and ask a question in relation to that example.  I suggest you start from
scratch, this time using scripts, so that your work is recorded and
replayable.

David J.

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], [email protected]
  Subject: Re: Reset sequence to current maximum value of rows
  In-Reply-To: <CAKFQuwY4PXdUYWxWzZ+idD64GLA2vrKf_UDcSPf=5VuYSDNRUA@mail.gmail.com>

* 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