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 1trgIy-007Kb4-IG for pgsql-general@arkaria.postgresql.org; Mon, 10 Mar 2025 16:48:40 +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 1trgIx-00FQfk-1d for pgsql-general@arkaria.postgresql.org; Mon, 10 Mar 2025 16:48:39 +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 1trgIw-00FQf7-Mq for pgsql-general@lists.postgresql.org; Mon, 10 Mar 2025 16:48:38 +0000 Received: from mail-yw1-x1129.google.com ([2607:f8b0:4864:20::1129]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1trgIv-0023q3-00 for pgsql-general@lists.postgresql.org; Mon, 10 Mar 2025 16:48:37 +0000 Received: by mail-yw1-x1129.google.com with SMTP id 00721157ae682-6f768e9be1aso57650017b3.0 for ; Mon, 10 Mar 2025 09:48:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1741625316; x=1742230116; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=9fquE+QwIWF3DfbjlNp2DubWQPJEXQyLDv7FlPzpy+M=; b=c7USHasEUdp5iAG1HgQAPnwJ0qpItIsbFllKKbyThrF4aB0I58ax927QLTQizQpD+H /M2jydZG52ULY84sa4AGJUT6NXaJT+ol99vLoGV2ZdeNyZsGkSwxe6qcdtQYgVnP66kp W2hRegLcUSWP1ds231DJtD076hOISAs0DhRj0FWp04p+9NoEMgS1ykTFX6CqmkcXKoMi j7LqliKd22RxzfNm4CISwvs1Kq2sUczPoMgqIlX+qX5oxbo3HjgwX6gUHmfG7RhZenPf U9rlcYv50FHG2Ae6+z9EFSUFGnMBezfjQBuG91Sj2AHI2edZ6O9W10c1rmo1E02CCvsE 4ImA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741625316; x=1742230116; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=9fquE+QwIWF3DfbjlNp2DubWQPJEXQyLDv7FlPzpy+M=; b=S5QCWzcFq822Jg3BokAOh6g3AhvgoUlVB3JBocA+pFdA8NFrYA5/yDpmVymr2T0hu4 g48vTybYJk72j8/BTMcehy7ozyCo3KWupQ3vzZfEX7WOV8/3Fs7AQ1XXj/gH8klhWu97 apakAlj4Q8z1p1NVrJYZnbVCQqgz51CxnTU21l7BmjEaZLtmm6h/tCVL8QynmGBAwx1a MHs8LF755AaIG9gDHawRQBcImkO1iN230+uKRP14HlnwZY+OWPKOv7CufzaMJd9ZZSmz 6Oln74WKbSAV+DTPiKhylZA6Tlx4FCFw+Go3eO+gWeVUE1h/dtPYf/geoJ2foa8JXPcV IX3w== X-Forwarded-Encrypted: i=1; AJvYcCV3n4g6wtLCJII547WES6uWZTEMtK7/ITAfs5ifVdcG/cBW2W48qr6aNLg2OQsITJU8CqqUnyCk3yXmp6Py@lists.postgresql.org X-Gm-Message-State: AOJu0Yy32sZ+cg+nrTqAYKMT92UD9GePMMlmGrvHif9pX61n6u6/MeWg Frmbesi4N2+SKgdSIr6tE5oJeSjUB86N8zS9t86urxoBRO/LDzOQhmEhlT9IvBaRnjzL9hfF7/D VuivSi3NC9JAEcurGA4iBthKkMFTKSQ== X-Gm-Gg: ASbGncvT69WTSKZAKnzODvkFloiE+vIHDhIbaqhoobY6jiDqswQvoYZRQjXkYgsjFMz IEFCevYR5UgjKSV6TnqahL2OkiYb+lFN2Fs+htEjxeLGjo4fLsZpCfUAUuttvyanohBnK8fPWDv FvSCpDxSn5Kt8MvuROockKnWpRz32UwF8voKcNyHOPRls+4TF+easx+uM9Wlso X-Google-Smtp-Source: AGHT+IGSafLot3cGjaSkJKGYoD/FG3TTbJgI12CJu/woUK5wTrnlOFmVuWcpZmSTZrrZGS2/W/u4jz7hipbNFH1TE7s= X-Received: by 2002:a05:690c:23ca:b0:6f9:b189:3cbf with SMTP id 00721157ae682-6ff0a30e532mr2968987b3.11.1741625316329; Mon, 10 Mar 2025 09:48:36 -0700 (PDT) MIME-Version: 1.0 References: <018BB1D4-F0B5-4865-85AB-B12B9C20FAA7@thebuild.com> In-Reply-To: <018BB1D4-F0B5-4865-85AB-B12B9C20FAA7@thebuild.com> From: Igor Korot Date: Mon, 10 Mar 2025 11:48:24 -0500 X-Gm-Features: AQ5f1Jp6HUvqwE77k_fF09bOYtppKQFtulUVZgWlfyNmuPaiIzRnkYHUzBEhkHE Message-ID: Subject: Re: Big script execution To: Christophe Pettus Cc: Laurenz Albe , "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000004fdb3c062fffbe9b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004fdb3c062fffbe9b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thank you! On Mon, Mar 10, 2025, 11:37=E2=80=AFAM Christophe Pettus = wrote: > > > > On Mar 10, 2025, at 09:35, Igor Korot wrote: > > > > Will the tables also be deleted? > > The CREATE TABLE statements are part of this big transaction. > > Yes. DDL is transactional in PostgreSQL just like DML. > --0000000000004fdb3c062fffbe9b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Thank you!


On Mon, Mar 10, 2025, 11:37=E2=80=AFAM Christophe Pettus &l= t;xof@thebuild.com> wrote:


> On Mar 10, 2025, at 09:35, Igor Korot <ikorot01@gmail.com> w= rote:
>
> Will the tables also be deleted?
> The CREATE TABLE statements are part of this big transaction.

Yes.=C2=A0 DDL is transactional in PostgreSQL just like DML.
--0000000000004fdb3c062fffbe9b--