On Mon, Jun 10, 2024 at 5:16 PM David G. Johnston < david.g.johns...@gmail.com> wrote:
> On Mon, Jun 10, 2024 at 12:43 PM Ron Johnson <ronljohnso...@gmail.com> >> wrote: > > >> Most useful to you will be some number of "ALTER TABLE <foo> DISABLE >> TRIGGER ALL;" statements near the beginning of the file, and their "ALTER >> TABLE ... ENABLE TRIGGER ALL;" counterparts near the end of the file. >> >> > Have you just not heard of deferred constraints or is there some reason > besides deferring constraints that you'd want to use alter table in > transactional production code? > I mentioned bulk loading of data. Occasionally that's useful, even in a prod database.