Re: [SQL] Multiple postgresql functions in a single transaction

2008-02-05 Thread sad
or users -- think of it. So i advise to avoid reverting sequences ANYWAY. Even if you think that this would not cause a problem. > > -- Forwarded message -- > > From: Jyoti Seth <[EMAIL PROTECTED]> > > Date: Feb 6, 2008 11:51 AM > > Subject: [SQL]

Re: [SQL] Multiple postgresql functions in a single transaction

2008-02-05 Thread Jyoti Seth
Thanks. I am not using sequences. I tried an example and it worked. From: Robins Tharakan [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 06, 2008 12:54 PM To: Jyoti Seth Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Multiple postgresql functions in a single transaction It can be

Re: [SQL] Multiple postgresql functions in a single transaction

2008-02-05 Thread Robins Tharakan
ECTED]> > Date: Feb 6, 2008 11:51 AM > Subject: [SQL] Multiple postgresql functions in a single transaction > To: pgsql-sql@postgresql.org > > > Hi, > > I have two postgresql functions. One function is calling another function > for certain value. I want that these tw

[SQL] Multiple postgresql functions in a single transaction

2008-02-05 Thread Jyoti Seth
Hi, I have two postgresql functions. One function is calling another function for certain value. I want that these two functions work under single transaction so that even if the value gets generated in the second function and the first function that calls the second function fails. Then the value