| 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: | Whole Thread | Raw Message | 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 |