On 6/29/07, Dennis Daupert <[EMAIL PROTECTED]> wrote:
I have tables that mutually reference one another, which prevents initial
addition of data to the tables. EG:
"page_content_version_fkey" FOREIGN KEY (content_version, id) REFERENCES
content(version, page) ON UPDATE CASCADE ON DELETE CASCADE
"content_page_fkey" FOREIGN KEY (page) REFERENCES page(id) ON UPDATE CASCADE
ON DELETE CASCADE
Is there a way to temporarily disengage or silence or otherwise render
harmless those constraints to allow the data load? Postgresql 81
I tried running the data load inside a transaction, but no joy.
/dennis
It would be easier to mentally parse this and figure out what going on
if we had the full table definitions of both of the tables and the
various (primary|unique|foreign) keys involved.
-- Brandon
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
