[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Long running processes and commit writing to disk
From:       Paul Ramsey <pramsey () cleverelephant ! ca>
Date:       2022-04-08 16:51:01
Message-ID: C60C6748-7476-4EB9-AEA4-6304C120D692 () cleverelephant ! ca
[Download RAW message or body]

Build your loop in plpgsql with an exception handler to write out broken cases to a side table, and your good results to an output table.

> On Apr 8, 2022, at 9:38 AM, Shaozhong SHI <shishaozhong@gmail.com> wrote:
> 
> When long running processes got disrupted, one may not see any expected result.
> 
> How to make sure that the result of each operation is saved to disk in a loop?
> 
> Regards,
> 
> David
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]