Re: JDBC: pl/pgsql function runs but does not do anything

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Rob W <digital_illuminati(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: JDBC: pl/pgsql function runs but does not do anything
Date: 2009-07-13 14:37:32
Message-ID: A067CDE1-3025-4619-88A0-3BA8F05D0ED4@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Rob W 2009-07-13 14:46:03 Re: JDBC: pl/pgsql function runs but does not do anything
Previous Message Rob W 2009-07-13 14:23:27 JDBC: pl/pgsql function runs but does not do anything