Skip site navigation (1) Skip section navigation (2)

Re: Update & Lack of Error Message

From: <operationsengineer1(at)yahoo(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Update & Lack of Error Message
Date: 2006-01-27 00:13:45
Message-ID: 20060127001345.80365.qmail@web33314.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
--- Michael Fuhr <mike(at)fuhr(dot)org> wrote:

> On Thu, Jan 26, 2006 at 02:22:37PM -0800,
> operationsengineer1(at)yahoo(dot)com wrote:
> > i set up an update statement to update a unit's
> status
> > from incomplete to completed.
> > 
> > however, pgsql doesn't kick out an error message
> when
> > i try to update something that doesn't exist.
> 
> The database has no way of knowing that a certain
> number of rows
> updated (zero in your case) represents an error;
> that's something
> the application knows.  An update that affects zero
> rows is perfectly
> legitimate in many applications.
> 
> > i'm thinking about running a select to check the
> > existence of the serial number before running the
> > update.  that way, i can check that the serial 1.
> > exists and 2. hasn't already been updated and,
> based
> > on the result, kick out a message to the user as
> > appropriate.
> 
> Your API should provide a way to get the number of
> rows updated.
> What language and database interface are you using?
> 
> -- 
> Michael Fuhr
> 

ADOdb - and thanks for the idea.

i can run the query, check for rows updated and then
do whatever makes sense from that point.

a zero row update can still mean two things, though -
the serial doesn't exist or the serial exists, but
already has been updated to the new value.  i need to
decide if that distinction will be important enough to
differentiate the error messages.

thanks again.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

In response to

Responses

pgsql-novice by date

Next:From: Michael FuhrDate: 2006-01-27 02:59:22
Subject: Re: Update & Lack of Error Message
Previous:From: Michael FuhrDate: 2006-01-26 22:53:41
Subject: Re: Update & Lack of Error Message

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group