public inbox for [email protected]  
help / color / mirror / Atom feed
From: Bruno Wolff III <[email protected]>
To: [email protected]
Subject: COPY documentation with regard to references constraints
Date: Thu, 31 Oct 2024 06:38:32 -0500
Message-ID: <[email protected]> (raw)

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 references constraint wasn't 
set as deferrable, I could have rows for children before their parents 
in the COPY data and things still worked.






reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: COPY documentation with regard to references constraints
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox