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 1otm1B-0007XW-9t for pgsql-admin@arkaria.postgresql.org; Sat, 12 Nov 2022 08:37: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 1otm19-0004zr-Tp for pgsql-admin@arkaria.postgresql.org; Sat, 12 Nov 2022 08:37:35 +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 1otm19-0004zg-GV for pgsql-admin@lists.postgresql.org; Sat, 12 Nov 2022 08:37:35 +0000 Received: from mail-ot1-x336.google.com ([2607:f8b0:4864:20::336]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1otm15-00060d-Fm for pgsql-admin@lists.postgresql.org; Sat, 12 Nov 2022 08:37:34 +0000 Received: by mail-ot1-x336.google.com with SMTP id a7-20020a056830008700b0066c82848060so4028908oto.4 for ; Sat, 12 Nov 2022 00:37:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=Z/tTIJuJEDeh0taT3yEslejoZO//DbJGbGDtF0Tz8Nc=; b=M+XvJrUsjzwHU/2mCgyR3k9+iSWLX/dFHEdQz4Epe/xoztM8bvMSBhDHXvuL8iX4zq D4n0bi1H0c2j0tgZ/Wl2NT6AsBBdJ1+X5gOmIGgqxTyQj1nAZPknHNSqnRWAWrhOX/VA 60t2qBoIheXnAWm/H7XoFjIuXNMEbBDUw0kq3UHfHGJzJte8Iu2KnovoxrStBSfDYO9u pIXTiCUsYwxVpIDO5CPAAfLzQvfZJcAXV11LkyLUfZCK6Roz/Bnd4mgkegdhrAC6qSPa HIU2gfFaFJrGOhGZnonB/F4BGZsnxiSdfI3+I9m+2MjBtTNxr2jHyEHj0/io1bTdzze5 WVEQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=Z/tTIJuJEDeh0taT3yEslejoZO//DbJGbGDtF0Tz8Nc=; b=1uTmssOPFaWt+0sbgHefMlmof9Zl6tE5is7PipOgjF6aK6C63ReJb7IVXby3JJui6z mVYC8JcDBSy5+bm4xj19cLM6DDOADPfzaq5/JGI69NXOmN1FLMy46GDow+VyUjHu9J4l al62glOT660NKCk4Phaj0Yj3dUljZ8Tmvf59TgKSWWQL4woc4OBIoMV3xmRd4hhylEAv Mkv/j67Zuo4y/CdJgWoGCO4oI3rjyI6I22e01h+M6lKwRnNm3TjLJ5aITKFOjSFRgQVc kQPGvvtLaA6dInck3GnXODnoFRW18DmKZAD5PoK2ZvDQVZr5vW1+zgqAsKLxleBY6ike +t7g== X-Gm-Message-State: ANoB5pltjp+efqcpd0nlPYyLJ8HfEv9gLldQsgVnFIMvZnAmyNahY7NX kYNRrJaBU0IORai9cnBGKV/frsJuaWk= X-Google-Smtp-Source: AA0mqf6B2GIRkywn5AGT1ENwPP04zUVA44IHlAGSLBGAR9nqFa7x+sgohTL5+wGGkeJSXQquyy7Iaw== X-Received: by 2002:a05:6830:1057:b0:661:9030:6480 with SMTP id b23-20020a056830105700b0066190306480mr2939248otp.147.1668242250492; Sat, 12 Nov 2022 00:37:30 -0800 (PST) Received: from [192.168.88.10] (ip68-230-234-148.no.no.cox.net. [68.230.234.148]) by smtp.googlemail.com with ESMTPSA id cd5-20020a056830620500b00661b019accbsm1942197otb.3.2022.11.12.00.37.29 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 12 Nov 2022 00:37:30 -0800 (PST) Content-Type: multipart/alternative; boundary="------------sGWl9oJEdCutViBuIxz0FFV0" Message-ID: Date: Sat, 12 Nov 2022 02:37:29 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.2.2 Subject: Re: Persistent changes in rolled-back transactions Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: <9B0F9F61-113F-419E-BC6B-12C9DE0D5BE9@crazybean.net> From: Ron In-Reply-To: <9B0F9F61-113F-419E-BC6B-12C9DE0D5BE9@crazybean.net> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------sGWl9oJEdCutViBuIxz0FFV0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 11/11/22 17:18, Rui DeSousa wrote: > > >> On Nov 9, 2022, at 8:23 PM, David G. Johnston >> wrote: >> >> Or just read the documentation for the current version (I seem to recall >> it used to be non-transactional, maybe...doesn't matter now). > > In a lot of other databases DDL is not transactional and truncate is DDL — > most likely confusing it with another RDBMS systems. The first two RDBMS I dealt with had transactional DDL.  It's... /natural/, given that table definitions reside in a system catalog that's just a bunch of tables...  I was shocked to see how Oracle does it (and that they don't have integers). -- Angular momentum makes the world go 'round. --------------sGWl9oJEdCutViBuIxz0FFV0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 11/11/22 17:18, Rui DeSousa wrote:


On Nov 9, 2022, at 8:23 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:

Or just read the documentation for the current version (I seem to recall it used to be non-transactional, maybe...doesn't matter now).

In a lot of other databases DDL is not transactional and truncate is DDL — most likely confusing it with another RDBMS systems.

The first two RDBMS I dealt with had transactional DDL.  It's... natural, given that table definitions reside in a system catalog that's just a bunch of tables...  I was shocked to see how Oracle does it (and that they don't have integers).

--
Angular momentum makes the world go 'round.
--------------sGWl9oJEdCutViBuIxz0FFV0--