Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uNXWP-0044Ma-DO for pgsql-admin@arkaria.postgresql.org; Fri, 06 Jun 2025 13:54:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uNXWM-00Afdr-96 for pgsql-admin@arkaria.postgresql.org; Fri, 06 Jun 2025 13:54:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uNXWL-00AfZu-RX for pgsql-admin@lists.postgresql.org; Fri, 06 Jun 2025 13:54:10 +0000 Received: from mail-oo1-xc31.google.com ([2607:f8b0:4864:20::c31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uNXWK-000aJr-2T for pgsql-admin@lists.postgresql.org; Fri, 06 Jun 2025 13:54:09 +0000 Received: by mail-oo1-xc31.google.com with SMTP id 006d021491bc7-60be8b6f1e2so1118491eaf.1 for ; Fri, 06 Jun 2025 06:54:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1749218048; x=1749822848; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=N81E5GKqNFhv56a69g88+yhc5gisRw+gmekOHc/u4do=; b=hwvfRIcmHRp/klJHiwt2/CdBaH0x7pHUOMUX1/tq0BPUNwWFjl7xaGHyE80fwThWAz 2+OwGhLxlLgmvt050K1KeZztaksVTlp1Rh99+AkSGykqwr5pcKft3kJJhBqfzB23JIlF BDZQVvaHDxEMENKeLKAyGJeOJdFc3xj6HUDyWdjAVVymZcQXqiAI5RrtqG6RK/sMv4GJ tM7IPvrnBk7GRltk5g9+952GhMbwjGwZsgPahNEUc81NR9/lvkcO1l2zey/PImRxA7Lp l6q44dQ9vDbSzeOc4Y+JZy9CcuGdrnmmkPQbSTPYZWYPBBt5LoX37eBcAPPrZHWiOE4J N/tQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1749218048; x=1749822848; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=N81E5GKqNFhv56a69g88+yhc5gisRw+gmekOHc/u4do=; b=Ud0lUL7rLthgYnXIFEQX7LBU5N+3/u6vhjsy+gHUj2uhtTxGm5d+sQz0hKzn/+T6k9 OjsGLY/dueNqlTwFisGlhifzjIR3q3Al8mL1kaJnMCwU1996doJw4UGgoXeloeHFZMqT q9A7kH7EnKZk8+WdJYLZt4eidBDA9wd8ysLwuvFU10p+AsnEPnqxuidrhQyrQt8qc/1N 8W/u4n8dPrwh6Y7uvYFzi9jTnuQelrM2RszSlNzSirS1UjB35Mifq3BrF9BVczpzAkqp 7ZLj99y19MqA2+YFpYGqUpWB4+v//LijLnOiiGSQDn8B+V2nsw3zm2vz5bbajuza+rom qwBA== X-Gm-Message-State: AOJu0YzzzKfuMMY6ORE98ZxXnOjuRhaItp9I8escstz/4ERApfNcekti 6sarp7CgLOt4xBJIZI3e5QN4dzwa5avpepzxUumDnVJMGu8PP1n7rejEaHAR35MUzPPZyan5IfC qlkfQ/9ic8d2RRAcQEy0FzGjFZBmprzA= X-Gm-Gg: ASbGncvome/r1xaqOub7Sq7xdWmAOPkpfGWS6VYq+3RnJMVBkjPQeb7mlj+tqRzMxNz hr0gAFjNuTZQSuOwHDPACo9XiVCQX+xnc0DDGeE7Othf+R1eeeeNGHbROz1TVUsWg7k0885H5DV QsyAuZHq9lwHycSnWz9rj0mi9f5J0pcqoxY1xveJg5H31NxsMJq8++YfkrORXjJl5L1w== X-Google-Smtp-Source: AGHT+IFix4NbOF80GX/qcGXUT5TUALhU4gaR+qoe0jduNOnW8sVb7FzmueQNrxMoLc2Y1rkqIOGyICO3W2OyJ1Pf4LQ= X-Received: by 2002:a05:6820:f09:b0:60f:36e2:27ca with SMTP id 006d021491bc7-60f3cf77304mr1907730eaf.7.1749218048148; Fri, 06 Jun 2025 06:54:08 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:6a53:0:b0:5c9:f01c:52e7 with HTTP; Fri, 6 Jun 2025 06:54:07 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Fri, 6 Jun 2025 06:54:07 -0700 X-Gm-Features: AX0GCFsNMBMhV7EbD69CFKDZNDMeTT6Hdcv9yDveYkaVbsatLHAF-P5S7skBU6w Message-ID: Subject: Re: order of pg_dump command "create sequence" To: =?UTF-8?B?0JDQvdGC0L7QvSDQk9C70YPRiNCw0LrQvtCy?= Cc: "pgsql-admin@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000650ab40636e7902b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000650ab40636e7902b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Friday, June 6, 2025, =D0=90=D0=BD=D1=82=D0=BE=D0=BD =D0=93=D0=BB=D1=83= =D1=88=D0=B0=D0=BA=D0=BE=D0=B2 wrote: > > /* create a function that will move the sequence */ > CREATE FUNCTION public.gen_id() RETURNS character varying > LANGUAGE sql IMMUTABLE AS > $$ > SELECT 'PREFIX_'||nextval('public.my_seq'::regclass)::VARCHAR; > $$; > > > Stating immutable is a lie and the breakage is on your head for violating using only immutable functions in generated expressions. David J. --000000000000650ab40636e7902b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Friday, June 6, 2025, =D0=90=D0=BD=D1=82=D0=BE=D0=BD =D0=93=D0=BB=D1=83= =D1=88=D0=B0=D0=BA=D0=BE=D0=B2 <a.glushakov86@gmail.com> wrote:

/* crea= te a function that will move the sequence */
CREATE FUNCTION public.gen_id() RETURNS character varying
LANGUAGE sq= l IMMUTABLE AS
$$
SELECT 'PREFIX_'||nextval('public.my_seq'::regclass)::VARCHAR;
$$;



Stating imm= utable is a lie and the breakage is on your head for violating using only i= mmutable functions in generated expressions.

D= avid J.

--000000000000650ab40636e7902b--