Re: COPY documentation with regard to references constraints

2024-10-31 Thread Dominique Devienne
On Thu, Oct 31, 2024 at 1:04 PM Bruno Wolff III wrote: > I was unable to find any documentation clarifying if using COPY to load a > table with rows referencing others rows in the same table, whether I > had to worry about ordering of the input. > What I found (in 17) is that even if the reference

Re: COPY documentation with regard to references constraints

2024-10-31 Thread Laurenz Albe
On Thu, 2024-10-31 at 06:38 -0500, Bruno Wolff III wrote: > I was unable to find any documentation clarifying if using COPY to load a > table with rows referencing others rows in the same table, whether I > had to worry about ordering of the input. I cannot find it in the documentation either, b

Re: COPY documentation with regard to references constraints

2024-10-31 Thread Bruno Wolff III
On Thu, Oct 31, 2024 at 13:15:34 +0100, Dominique Devienne wrote: AFAIK, DEFERRABLE is for temporary violations crossing statement boundaries, to postpone the enforcement of FKs at COMMIT time of the transaction. While a single COPY is just one statement, so whether a temporary violation for