Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Problem calling stored function
- From: Oliver Jowett <oliver(at)opencloud(dot)com>
- To: Francesco Storti <francesco(dot)storti(at)gmail(dot)com>
- Cc: pgsql-jdbc(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Subject: Re: Problem calling stored function
- Date: Sat, 19 Jan 2008 00:56:00 +1300
Francesco Storti wrote:
2008/1/17, Tom Lane tgl(at)sss(dot)pgh(dot)pa(dot)us <mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>: Should work. Maybe you're rolling back the transaction later, or something like that? regards, tom laneThank for the answer first ;)I use rollback only if throwed an SQL exception.
You never call commit() so the transaction will be rolled back when you close the connection. (I'm assuming you have autocommit off, you didn't include your connection setup code)
-O
- Follow-Ups:
- Re: Problem calling stored function
- From: Francesco Storti
- Re: Problem calling stored function
- References:
- Problem calling stored function
- From: Francesco Storti
- Re: Problem calling stored function
- From: Tom Lane
- Re: Problem calling stored function
- From: Francesco Storti
- Problem calling stored function
- Prev by Date: Re: Problem calling stored function
- Next by Date: Re: Problem calling stored function
- Previous by thread: Re: Problem calling stored function
- Next by thread: Re: Problem calling stored function
- Indexes: