From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Persistent changes in rolled-back transactions |
Date: | 2022-11-12 08:37:29 |
Message-ID: | bffe5007-512b-fb4c-aafd-feb047b7fcf3@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 11/11/22 17:18, Rui DeSousa wrote:
>
>
>> On Nov 9, 2022, at 8:23 PM, David G. Johnston
>> <david(dot)g(dot)johnston(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Rui DeSousa | 2022-11-12 18:08:26 | Re: How to test replication without doing a failover |
Previous Message | Edwin UY | 2022-11-12 06:24:20 | Re: How to test replication without doing a failover |