I'm not going to be able to send the output of the script without 
fudging the table names, and that might be more trouble than it's 
worth.

Anyway, the summary should give you some idea of what I'm dealing with:

~7,000 set add table statements for tables with primary keys
~9,000 table add key/set add table statement pairs for tables without 
primary keys

So I have a 25,000 line slonik script (which includes a relatively 
insignificant number of sequences, too).

-tfo

On Jul 28, 2004, at 6:07 PM, Darcy Buskermolen wrote:

> Any chance you can send me the output of your dynamic script that you 
> are
> feeding to slonik so that I can attempt to come up with a working 
> patch for
> you.  At this point I'm inclined to think that the problem lies in your
> script.  A nested recursion depth of 10,000 (which is the default) 
> should me
> more than enough to handel any DB setup I've ever seen.
>
> Also if you would like to try the following patch, it appears to solve 
> a
> problem where slonik would segfault, if you were to fail to pass in an
> optional parameter. It may solve the issue for you but I'm not 
> expecting it
> would.
>
> http://www.dbitech.ca/dbutil.patch