Re: JDBC: pl/pgsql function runs but does not do anything - Mailing list pgsql-novice

From John DeSoi
Subject Re: JDBC: pl/pgsql function runs but does not do anything
Date
Msg-id A067CDE1-3025-4619-88A0-3BA8F05D0ED4@pgedit.com
Whole thread Raw
In response to JDBC: pl/pgsql function runs but does not do anything  (Rob W <digital_illuminati@yahoo.com>)
List pgsql-novice
On Jul 13, 2009, at 10:23 AM, Rob W wrote:

> At first I thought it was not running at all, so I put in "RAISE
> INFO" statements to see if it was actually working -- and those did
> indeed print statements. So I know for sure it is actually running.
> I tried commenting out different things in case it was failing
> silently, but that made no difference. Running the stored procedure
> does not return any errors or warnings.
>
> There must be something really obvious I'm overlooking?

Are you running inside a transaction that is being cancelled or not
committed?



John DeSoi, Ph.D.





pgsql-novice by date:

Previous
From: Rob W
Date:
Subject: JDBC: pl/pgsql function runs but does not do anything
Next
From: Rob W
Date:
Subject: Re: JDBC: pl/pgsql function runs but does not do anything