Re: AW: [HACKERS] inserts/updates problem under stressing !

At 12:54 26/07/99 +0400, Oleg Bartunov wrote:
>Andreas,
>
>I rewrote my function but got a problem how to know if update fails:
>
>CREATE FUNCTION "acc_hits" (int4) RETURNS datetime AS '
>Declare
> keyval Alias For $1;
> cnt int4;
> curtime datetime;
>Begin
> curtime := ''now'';
> Update hits set count = count + 1,last_access = curtime where msg_id =
keyval;
> if Not Found then
> ??????????

You need a patch to plpgsql with adds:

GET DIAGNOSTICS SELECT PROCESSED INTO num_of_rows_affected;

where num_of_rows_affected is a local variable.

The patch is currently with Jan, who is quite busy.

> -- first_access inserted on default, last_access is NULL
> Insert Into hits (msg_id,count) values (keyval, 1);
> End If;
> return curtime;
>End;
>' LANGUAGE 'plpgsql';
>
>
>
> regards,
>
> Oleg
>
>
>
>
>
>
>On Mon, 26 Jul 1999, Zeugswetter Andreas IZ5 wrote:
>

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.C.N. 008 659 498) | /(@) ______---_
Tel: +61-03-5367 7422 | _________ \
Fax: +61-03-5367 7430 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/