[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [GENERAL] Catch of ERROR in PLPGSQL
From: Shaun Clements <ShaunC () relyant ! co ! za>
Date: 2005-03-31 9:05:05
Message-ID: 100F78F2B203444BB161BBA7077FF6131CD9BF () srldbexc003 ! relyant ! co ! za
[Download RAW message or body]
Begin
Exception
of a basic Function.
is provided for.
What I was thinking then, it to create separate functions for the INSERT and
UPDATE
which take parameters, for the table, column, and values.
Which I can then make use of the EXCEPTION.
Kind Regards,
Shaun Clements
-----Original Message-----
From: Richard Huxton [mailto:dev@archonet.com]
Sent: 31 March 2005 09:10 AM
To: Shaun Clements; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Catch of ERROR in PLPGSQL
Shaun Clements wrote:
> Thanks for your response.
> I unfortunately have to use 7.3.
> Will try the Exception wrap. It does appear in the manual.
No it doesn't. Version 7.3 doesn't have any programmatic exception
handling. Perhaps you are reading the wrong version of the manuals?
--
Richard Huxton
Archonet Ltd
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: [GENERAL] Catch of ERROR in PLPGSQL</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Begin</FONT>
<BR><FONT SIZE=2>Exception</FONT>
<BR><FONT SIZE=2>of a basic Function.</FONT>
<BR><FONT SIZE=2>is provided for.</FONT>
<BR><FONT SIZE=2>What I was thinking then, it to create separate functions for the \
INSERT and UPDATE</FONT> <BR><FONT SIZE=2>which take parameters, for the table, \
column, and values.</FONT> <BR><FONT SIZE=2>Which I can then make use of the \
EXCEPTION.</FONT> </P>
<P><FONT SIZE=2>Kind Regards,</FONT>
<BR><FONT SIZE=2>Shaun Clements</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Richard Huxton [<A \
HREF="mailto:dev@archonet.com">mailto:dev@archonet.com</A>]</FONT> <BR><FONT \
SIZE=2>Sent: 31 March 2005 09:10 AM</FONT> <BR><FONT SIZE=2>To: Shaun Clements; \
pgsql-general@postgresql.org</FONT> <BR><FONT SIZE=2>Subject: Re: [GENERAL] Catch of \
ERROR in PLPGSQL</FONT> </P>
<BR>
<P><FONT SIZE=2>Shaun Clements wrote:</FONT>
<BR><FONT SIZE=2>> Thanks for your response.</FONT>
<BR><FONT SIZE=2>> I unfortunately have to use 7.3.</FONT>
<BR><FONT SIZE=2>> Will try the Exception wrap. It does appear in the \
manual.</FONT> </P>
<P><FONT SIZE=2>No it doesn't. Version 7.3 doesn't have any programmatic exception \
</FONT> <BR><FONT SIZE=2>handling. Perhaps you are reading the wrong version of the \
manuals?</FONT> </P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2> Richard Huxton</FONT>
<BR><FONT SIZE=2> Archonet Ltd</FONT>
</P>
</BODY>
</HTML>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic