Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pNlUH-0006QE-I5 for pgsql-general@arkaria.postgresql.org; Fri, 03 Feb 2023 02:07:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pNlUG-0001k2-BZ for pgsql-general@arkaria.postgresql.org; Fri, 03 Feb 2023 02:07:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pNlUF-0001YU-SH for pgsql-general@lists.postgresql.org; Fri, 03 Feb 2023 02:07:35 +0000 Received: from mail-pf1-x42c.google.com ([2607:f8b0:4864:20::42c]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pNlU8-0005hq-Rv for pgsql-general@lists.postgresql.org; Fri, 03 Feb 2023 02:07:34 +0000 Received: by mail-pf1-x42c.google.com with SMTP id u5so2583046pfm.10 for ; Thu, 02 Feb 2023 18:07:28 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=S8d1NgX3IjjErzvVJKXJ3MfQwTj1WzO94rM/EmlgdzU=; b=PAz99RBhhQ2/NVQb6rmRSOJN/DE0nE7y/RNkDTIZ1DJOEGoETkBcLFPD/EL2s2e8za tllEipDL1HilPY7LgcFRrUsKhsDvAcNsRN9hfC5eSomvpZOxiDU5xkpQUdeQUFxkq/vm LnJuMAtO0yRKB9/tPpAUDTiqWf1NBC0z1isrleoKTDiMEWqKSmBuFfGDdkT/Bj1xqHGw 0NCx92sUlj5w7o34NvYK+ciDCXXKd/adAKyVZLbNNfIwe82gt8GoMZ0VDsJD1kDJSKrr gkI/s3DwzxrfmZ0QbHDhe8px+VTsdrkt5E4JFdeCFx5VBMj7UH5sszRStInAghA+Ntyp lgRA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=S8d1NgX3IjjErzvVJKXJ3MfQwTj1WzO94rM/EmlgdzU=; b=CKn8aGyvlGV+ZZr9L+gg8zxjV9K/0kA7CLMphMQ3E0xerr/7J7uJqRTPi1ImKVUWGq mCg2yIOq59Lby6+xwh0WN2MadVkUkgWRNpOvPJvnQhWFZBzcHckHGOArouloFcLVvsXe 8UXWzcrVY/xyNAdYtzqHPu6O2Bw3pVPfTNEeH1XfZ4R3u+xxv+eNn4M9SAhRBDGyaLxq BBeZp0tykl7K0yE8qt9dHUBtkbpPfq9MBZQS9Gx0GFIB/wYBuX3gK35FX9QOu+5h/rgh kcjpaHJQKcSEmJURN2h3VuF9j5NwEZVpxAuKRwot+f540XFmFfWwJqY0x0j+VRodjnlL O2/w== X-Gm-Message-State: AO0yUKUggNciSjOk9rPfyOrsZBASTk0JpbK0w+07nsjRb6tpRMZoyOBk AKd7FlJaYAy5mTeoCN5iXTg= X-Google-Smtp-Source: AK7set91em8JQD+2w0T4Wq59ssWsB4BNd4akFhrHYXJb7iiray6TPq1UJVMtYq9LkFvk549aXOb65Q== X-Received: by 2002:a05:6a00:1249:b0:594:1f1c:3d2b with SMTP id u9-20020a056a00124900b005941f1c3d2bmr4038745pfi.0.1675390047590; Thu, 02 Feb 2023 18:07:27 -0800 (PST) Received: from smtpclient.apple (2603-800c-2100-0b85-9400-1afb-276a-698d.res6.spectrum.com. [2603:800c:2100:b85:9400:1afb:276a:698d]) by smtp.gmail.com with ESMTPSA id y2-20020a62b502000000b00581013fcbe1sm362169pfe.159.2023.02.02.18.07.26 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 02 Feb 2023 18:07:27 -0800 (PST) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Rob Sargent Mime-Version: 1.0 (1.0) Subject: Re: Sequence vs UUID Date: Thu, 2 Feb 2023 16:07:14 -1000 Message-Id: References: Cc: Ron , pgsql-general In-Reply-To: To: Benedict Holland X-Mailer: iPhone Mail (20B101) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Feb 2, 2023, at 1:26 PM, Benedict Holland wrote: >=20 > =EF=BB=BF > No idea at all. We had the data for the insert and had to insert it again.= It was extremely confusing but oh boy did it wreck our systems. >=20 > Thanks, > Ben Someone has a baked-in uuid in a script I suspect.=20 =20 >=20