[HACKERS] server crash on recursive function invocation

2006-05-31 Thread Ali Baba
hi,i was just trying recursive function invocation and got a server crash when i changed a GUC variable max_stack_depth,  to a high number. fallowing is what i have tried.select max_val from pg_settings where name='max_stack_depth'; -- returns 2097151set max_stack_depth=2097151;CREATE OR REPLACE FU

Re: [HACKERS] transactions not working properly ?

2005-08-18 Thread Ali Baba
ael Fuhr <[EMAIL PROTECTED]> wrote: > > > [This question would probably be more appropriate > in > > pgsql-general > > than in pgsql-hackers.] > > > > On Wed, Aug 17, 2005 at 05:53:14AM -0700, Ali Baba > > wrote: > > > can any one descri

[HACKERS] transactions not working properly ?

2005-08-17 Thread Ali Baba
Hi, can any one describe how the transaction are being handled in postgres. i.e. function given below should actually insert the desire values in test table but it do not save them. START TRANSACTION; create or replace function testFunc() returns int as $$ declare x integer; begin x := 1; inse

[HACKERS] Adding column in pg_proc

2005-04-18 Thread Ali Baba
Hello, if i need to add a column in pg_proc ,is any body can give me overview to do this. Thanks, Asif Ali __ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250 ---

[HACKERS] custome exception handling support ?

2005-03-20 Thread Ali Baba
Hi, i want to add support for exceptions that are supported in oracle, in plpgsql. mainly i am want to add custome exceptions support in plpgsql. like in Oracle we use EXCEPTION myexp can any body help me. Regards, Asif Ali. __ Do You Yahoo!? T

[HACKERS] Exception handiling

2005-03-16 Thread Ali Baba
Hi, i want to add support for oracle exception's like no_data in plpgsql, can anybody guide me on this. Regards, Asif Ali. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---

[HACKERS] Exception ERROR Code

2005-03-05 Thread Ali Baba
Hi , I am looking for the way to get the error code corresponding to the exception in plpgsql. Can any body guide me. Thanks, Asif Ali __ Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web http://birthday.y