Search Postgresql Archives
COPY documentation with regard to references constraints
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: COPY documentation with regard to references constraints
- From: Bruno Wolff III <bruno@xxxxxxxx>
- Date: Thu, 31 Oct 2024 06:38:32 -0500
- Mail-followup-to: Bruno Wolff III <bruno@xxxxxxxx>, pgsql-general@xxxxxxxxxxxxxxxxxxxx
- User-agent: Mutt/1.12.1 (2019-06-15)
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.
[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]