Date: Thu, 13 Jun 2024 13:09:51 -0700 (PDT)
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Reset sequence to current maximum value of rows
In-Reply-To: <CANzqJaB0OeAchVgnTznmPTbo9Y-H9r9g7S=TqJb25eX_KodcRA@mail.gmail.com>
Message-ID: <bcf7b38-857e-b44c-a0c5-71bfc1f52b9c@appl-ecosys.com>
References: <387fa6c2-5de-f24-d522-46282597703@appl-ecosys.com> <CANzqJaAavydD4XMgkXRUQ_=aAFOGBMVBCKfeB0PnhrZrAWbgng@mail.gmail.com> <c141507f-a21-65dd-55fa-bd9bad7b9fe4@appl-ecosys.com> <CANzqJaB0OeAchVgnTznmPTbo9Y-H9r9g7S=TqJb25eX_KodcRA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset=US-ASCII
Archived-At: <https://www.postgresql.org/message-id/bcf7b38-857e-b44c-a0c5-71bfc1f52b9c%40appl-ecosys.com>
Precedence: bulk

On Thu, 13 Jun 2024, Ron Johnson wrote:

> No need to do that.  Just write:
> INSERT INTO public.companies (company_name, , industry, status)
>    VALUES ('Berkshire Hathaway', 'Conglomerate', 'Mumble');
>
> The next value of companies_org_nbr_seq will automatically be taken and
> inserted  into the table.

Ron,

Aha! So it's likely that by listing the PK column name in the list of
columns to be inserted was what caused the problem? No need to specify
DEFAULT for it?

I'm writing a script to enter all contact within these companies. I'll leave
out 'person_nbr' in the list of columns and DEFAULT at the beginning of the
VALUES () section.

I didn't pick this up in my readings.

Thank you,

Rich