pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Michael Fuhr <mike@fuhr.org>
To: Penchalaiah P. <penchalaiahp@infics.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: hi let me know the solution to this question
Date: Mon, 17 Jul 2006 23:34:42 -0600
Message-ID: <20060718053442.GA9694@winnie.fuhr.org> (raw)
In-Reply-To: <A70AE049E81A6A40879D5DC0AC8C38C906B08220@venus.infics.com>
References: <A70AE049E81A6A40879D5DC0AC8C38C906B08220@venus.infics.com>

On Tue, Jul 18, 2006 at 10:46:29AM +0530, Penchalaiah P. wrote:
> Can u let me know if at all any system defined variable exists to check
> whether insert , update , and delete is successfully executed in a
> stored procedure........
> 
> So that I can perform some steps based on the  result of execution if
> possible please send me the sample code...............

Depending on what you mean by "successfully executed," see "Obtaining
the Result Status" or "Trapping Errors" in the PL/pgSQL documentation
(error trapping is available in 8.0 and later).

http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTIC...
http://www.postgresql.org/docs/8.1/interactive/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPIN...

-- 
Michael Fuhr



view thread (5+ messages)  latest in thread

Message-ID: <20060718053442.GA9694@winnie.fuhr.org>
Permalink:  ../20060718053442.GA9694@winnie.fuhr.org/
Also on:    postgresql.org/message-id/20060718053442.GA9694@winnie.fuhr.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: mike@fuhr.org, penchalaiahp@infics.com
  Subject: Re: hi let me know the solution to this question
  In-Reply-To: <20060718053442.GA9694@winnie.fuhr.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox