Re: [GENERAL] Stored Procedures woes

2004-08-19 Thread Jochem van Dieten
"Andrew Hall" wrote: We are using a number of stored procedures that are called often from our client programs. I include one here as an example. The problem we are seeing is that when executing some of these that deal with a large number of records, they begin execution and never return. The proce

Re: [GENERAL] Stored Procedures woes

2004-08-19 Thread Tom Lane
Oliver Elphick <[EMAIL PROTECTED]> writes: >> We are using a number of stored procedures that are called often from our >> client programs. > Are you somehow setting off an infinite recursion? How is this being > called? I doubt it would be an infinite-recursion problem, as that would soon lead

Re: [GENERAL] Stored Procedures woes

2004-08-19 Thread Oliver Elphick
On Thu, 2004-08-19 at 10:53, Andrew Hall wrote: > Hello, > > We are using a number of stored procedures that are called often from our > client programs. I include one here as an example. The problem we are seeing > is that when executing some of these that deal with a large number of > records, t

[GENERAL] Stored Procedures woes

2004-08-19 Thread Andrew Hall
Hello, We are using a number of stored procedures that are called often from our client programs. I include one here as an example. The problem we are seeing is that when executing some of these that deal with a large number of records, they begin execution and never return. The process handling t