Re: How do I save data and then raise an exception?

["Rob Richardson" <Rob.Richardson@xxxxxxxxxxx>]

Title: Re: [GENERAL] How do I save data and then raise an exception?

RAISE NOTICE won't help (I don't think) because the notice isn't visible from inside the C++ application, so the user won't know that a problem occured. 

 

I think I just came up with a thoroughly ugly idea.  The database supports an annealing shop, in which coils are assigned to charges.  After the check fails, I end up with coils assigned to a charge that does not exist.  I could set up a job that runs every minute and checks all coils with status "Assigned" to make sure that the associated charges actually exist.  That would fix another recurring problem, in which a user intentionally deletes a charge but the charge's coils stay assigned to that charge.  We haven't tracked that down yet, but this job would fix that too.

 

Now all I have to do is learn how to set up a job.  I only know about them from overhearing colleagues talking.

 

RobR

---

From: Jaime Casanova [mailto:jcasanov@xxxxxxxxxxxxxxxxxxx]
Sent: Thu 10/2/2008 10:11 PM
To: Alvaro Herrera
Cc: Rob Richardson; pgsql-general@xxxxxxxxxxxxxx
Subject: Re: [GENERAL] How do I save data and then raise an exception?

On Thu, Oct 2, 2008 at 8:44 PM, Alvaro Herrera
<alvherre@xxxxxxxxxxxxxxxxx> wrote:
> Rob Richardson wrote:
>
>> Here's what I need to do:
>>
>> IF query_check_fails THEN
>>     UPDATE some_table SET some_value = 0 WHERE some_condition_is_true;
>>     RAISE EXCEPTION 'Look, you idiot, do it right next time!';
>> END;
>>
>> I need the update to work, but I need to raise the exception so the C++
>> code recognizes the error.  How can I do both?
>
> You need an autonomous transaction, which Postgres does not support
> directly but you can implement using dblink or a plperl function that
> connects back to the database.
>

what about RAISE NOTICE?

--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157