Re: disable foreign key checks

On 08/06/13 15:50, Fabian Groffen wrote:

On 07-06-2013 16:29:35 +0200, Gijs Molenaar wrote:

...

Hi Martin,

Thanks for your answer. I’ve implemented a topological sort for the foreign key relations. This works, but not for cyclic references. I know one should not create cyclic references, but it can still happen. In this case, there is no way to automatically flush these tables, right?

within a transaction you can insert those statements, at the time you do COMMIT it should all be satisfied, though

Hi Fabian, I'm not sure what you say here. If I try to remove the rows in a transaction I also get a foreign key violation error. Thanks, - Gijs -- Gijs Molenaar http://www.astro.uva.nl/people/gijs-molenaar/