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
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
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
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
---
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
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
---
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