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

2008-02-05 Thread sad
Robins Tharakan wrote: > > It can be done, but it depends on how you are generating the value in the > > first function. > > If you sequences though you may have to take care of reverting it > > yourself. Sequences had been constructed in this manner not to cause pain for users -- think of it. S

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
> It can be done, but it depends on how you are generating the value in the > first function. > If you sequences though you may have to take care of reverting it > yourself. > > *Robins* > > > -- Forwarded message -- > From: Jyoti Seth <[EMAIL PROTECTED]> > Date: Feb 6, 2008 11:51 A