Search Postgresql Archives

Re: Multiple tables row insertions from single psql input file

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Jun 10, 2024 at 12:43 PM Ron Johnson <ronljohnsonjr@xxxxxxxxx> 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?

David J.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux