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>
In-Reply-To: <1b139d9a-b95f-f7c8-52fb-9d7442c69ad9@appl-ecosys.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Thu, 13 Jun 2024 12:35:01 -0700
Message-ID: <CAKFQuwY4PXdUYWxWzZ+idD64GLA2vrKf_UDcSPf=5VuYSDNRUA@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="0000000000008f484d061aca9a88"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwY4PXdUYWxWzZ%2BidD64GLA2vrKf_UDcSPf%3D5VuYSDNRUA%40mail.gmail.com>
Precedence: bulk

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

On Thu, Jun 13, 2024 at 11:24=E2=80=AFAM Rich Shepard <rshepard@appl-ecosys=
.com>
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.

--0000000000008f484d061aca9a88
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 11:24=E2=80=AFAM 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">On Thu, 13 Jun 2024, David G. Johnston wro=
te:<br>
<br>
&gt; You need to show your work here.=C2=A0 As your PK is a number it canno=
t have a<br>
&gt; company name as a value and so this doesn&#39;t make sense.<br><br>
insert into companies (company_nbr,company_name,industry,status) values<br>
(DEFAULT,&#39;new company name&#39;,&#39;Industry&#39;,&#39;Opportunity&#39=
;)<br>
<br>
With DEFAULT as the company_nbr why can&#39;t the company_name not have a v=
alue?<br></blockquote><div><br></div><div><div class=3D"gmail_default" styl=
e=3D"font-family:arial,helvetica,sans-serif">Because you specified company_=
name in the column listing for the things you are inserting values for.=C2=
=A0 So in column position 2 you must have a value than can be inserted into=
 the company_name column.=C2=A0 It is utterly immaterial how you specified =
the value for column position 1.</div></div><div><br></div><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid r=
gb(204,204,204);padding-left:1ex">
<br>
&gt; If you use the default when inserting the next value in the sequence i=
s<br>
&gt; used.<br>
<br>
Yes, that&#39;s the theory. It didn&#39;t work for me and why it didn&#39;t=
 is what I<br>
want to understand.<br><br></blockquote><div><br></div><div class=3D"gmail_=
default" style=3D"font-family:arial,helvetica,sans-serif">We can&#39;t help=
 you understand if you don&#39;t show a complete working example and ask a =
question in relation=C2=A0to that example.=C2=A0 I suggest you start from s=
cratch, this time using scripts, so that your work is recorded and replayab=
le.</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:ari=
al,helvetica,sans-serif">David J.</div></div></div>

--0000000000008f484d061aca9a88--