Feedback-ID: i76984098:Fastmail
Message-ID: <0f40b8e8-a4a1-4c9b-9c90-7402e9edb628@aklaver.com>
Date: Thu, 13 Jun 2024 11:54:18 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Reset sequence to current maximum value of rows
To: Rich Shepard <rshepard@appl-ecosys.com>,
 "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <387fa6c2-5de-f24-d522-46282597703@appl-ecosys.com>
 <CANzqJaAavydD4XMgkXRUQ_=aAFOGBMVBCKfeB0PnhrZrAWbgng@mail.gmail.com>
 <c141507f-a21-65dd-55fa-bd9bad7b9fe4@appl-ecosys.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <c141507f-a21-65dd-55fa-bd9bad7b9fe4@appl-ecosys.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/0f40b8e8-a4a1-4c9b-9c90-7402e9edb628%40aklaver.com>
Precedence: bulk

On 6/13/24 11:38, Rich Shepard wrote:
> On Thu, 13 Jun 2024, Ron Johnson wrote:
> 

> Today I saw that I had missed one new company and entered it using DEFAULT
> for the company_nbr PK. When I looked at that table every company_name that
> I had added yesterday was changed to the one inserted today.

You sure you did not actually do an UPDATE without a WHERE?

> 
>> What does your table definition look like?
> 
>                                           Table "public.companies"
>      Column    |         Type          | Collation | Nullable 
> |                  Default
> 
> --------------+-----------------------+-----------+----------+--------------------------------------
>   company_nbr  | integer               |           | not null | 
> nextval('companies_org_nbr_seq'::regclass)
>   company_name | character varying(64) |           | not null | 
> '??'::character varying
>   url          | character varying(64) |           |          |
>   email        | character varying(64) |           |          |
>   industry     | character varying(24) |           | not null | 
> 'Other'::character varying
>   status       | character varying(20) |           | not null | 
> 'Opportunity'::character varying
>   comment      | text                  |           |          |
>   ea_nbr       | integer               |           |          | 0
>   ea_amt       | numeric(10,2)         |           |          | 0.00
> Indexes:
>      "organizations_pkey" PRIMARY KEY, btree (company_nbr)
> Foreign-key constraints:
>      "organizations_industry_fkey" FOREIGN KEY (industry) REFERENCES 
> industrytypes(ind_name) ON UPDAT
> E CASCADE ON DELETE RESTRICT
>      "organizations_status_fkey" FOREIGN KEY (status) REFERENCES 
> statustypes(stat_name) ON UPDATE CAS
> CADE ON DELETE RESTRICT
> Referenced by:
>      TABLE "locations" CONSTRAINT "locations_org_nbr_fkey" FOREIGN KEY
> (company_nbr) REFERENCES companies(company_nbr) ON UPDATE CASCADE ON DELETE
> RESTRICT
>      TABLE "people" CONSTRAINT "people_org_nbr_fkey" FOREIGN KEY
> (company_nbr) REFERENCES companies(c ompany_nbr) ON UPDATE CASCADE ON 
> DELETE
> RESTRICT
> 
> Rich
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com