Re: [GENERAL] [HACKERS] Stored procedure issue

2007-12-03 Thread Pavel Stehule
Hello On 03/12/2007, Dragan Zubac <[EMAIL PROTECTED]> wrote: > Hello > > What I have noticed is that when I don't use procedure > at all,there's only 2-5 locks in pg_locks,after I > start application which uses stored procedure the > number in pg_locks increase rapidly to steady 75 even > to 130 a

Re: [GENERAL] [HACKERS] Stored procedure issue

2007-12-02 Thread Dragan Zubac
Hello Here's the stored procedure itself,as well as the related tables involved in it's calculations. The idea for procedure is to find longest prefix match for destination number,try to find it in table 'billing' for particular users,find the price,and insert message into history and inqueue tabl