Re: disable foreign key checks

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 -- Fabian Groffen fabian@monetdb.org column-store pioneer http://www.monetdb.org/Home