BUG REPORT

Hi

I use Postgresql 7.1.1 compiled on a P3 running slackware 7.1 with
glibc-2.2.1 make-3.79.1 and gxx-2.95.2 and others dev tools upgraded if
needed ask me for more.

I create this function:

DROP FUNCTION inserisci(int4,int4,char(1));

CREATE FUNCTION inserisci(int4,int4,char(1)) RETURNS int4 AS '
DECLARE
        or      ALIAS FOR $1;
        gn      ALIAS FOR $2;
        gl      ALIAS FOR $3;
        temp    int4;
        riga    fr_tab_conv1%ROWTYPE;
BEGIN
FOR riga IN SELECT * FROM fr_tab_conv1 WHERE ordre >= or AND gnum = gn AND
glettre = gl ORDER BY ordre DESC LOOP
temp := riga.ordre +1;
UPDATE fr_tab_conv1 SET ordre = temp WHERE gnum=gn AND glettre=gl AND
ordre=riga.ordre ;
END LOOP;
return 0;
END;
' language 'plpgsql';

for this table

fiscal=# \d fr_tab_conv1
        Table "fr_tab_conv1"
 Attribute |     Type     | Modifier
-----------+--------------+----------
 gnum      | integer      | not null
 glettre   | character(1) | not null
 ordre     | integer      | not null
 txt       | text         |
Index: fr_tab_conv1_pkey

everything work fine if the query"FOR riga IN SELECT * FROM fr_tab_conv1
WHERE ordre >= or AND gnum = gn AND glettre = gl ORDER BY ordre DESC LOOP"
return something.... if not:

fiscal=# SELECT inserisci(2,1,'A');
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Server process (pid
1547) exited with status 11 at Tue May 29 23:02:33 2001
Terminating any active server processes...
Server processes were terminated at Tue May 29 23:02:33 2001
Reinitializing shared memory and semaphores
DEBUG:  database system was interrupted at 2001-05-29 23:01:47
DEBUG:  CheckPoint record at (0, 4144380)
DEBUG:  Redo record at (0, 4144380); Undo record at (0, 0); Shutdown FALSE
DEBUG:  NextTransactionId: 1554; NextOid: 36441
DEBUG:  database system was not properly shut down; automatic recovery in
progress...
DEBUG:  redo starts at (0, 4144444)
The Data Base System is starting up
Failed.
!# DEBUG:  ReadRecord: record with zero len at (0, 4170876)
DEBUG:  redo done at (0, 4170840)
DEBUG:  database system is in production state

.......
Great program hopping I'm helping improving it.
bye

--

"L'idea di base è estremamente semplice..."
©opyright Frank "Pazzooo" Contrepois (schiavista francese del '900)