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

bug in plpgsql???

From: "Alexander Zagrebin" <alexz(at)visp(dot)ru>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: bug in plpgsql???
Date: 2001-05-22 12:24:37
Message-ID: GPEFIGKNJAIDINJJPGOOAEMCCJAA.alexz@visp.ru (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi!

I try to work with trees in Postgres 7.1.1
My test script is
====================================================================
CREATE TABLE hierarchy

    parent      INTEGER,
    child       INTEGER
);

INSERT INTO hierarchy VALUES (1, 2);
INSERT INTO hierarchy VALUES (2, 4);
INSERT INTO hierarchy VALUES (3, 5);
INSERT INTO hierarchy VALUES (4, 5);

CREATE FUNCTION is_child(INTEGER, INTEGER) RETURNS BOOLEAN AS
'
DECLARE
-- Don't works!!!
    rec hierarchy%ROWTYPE;
-- Works!!!
    rec RECORD;
BEGIN
    RAISE DEBUG ''child is %, parent is %'', $1, $2;
    FOR rec IN SELECT * FROM hierarchy WHERE child = $1 LOOP
        RAISE DEBUG ''found parent %'', rec.parent;
        IF rec.parent = $2 OR is_child(rec.parent, $2) THEN
            RETURN TRUE;
        END IF;
    END LOOP;
    RETURN FALSE;
END;
'
LANGUAGE 'plpgsql';

SELECT is_child(5, 1);
====================================================================
If I declare "rec" as "RECORD", then all works fine:

2001-05-22 16:22:01 DEBUG:  child is 5, parent is 1
2001-05-22 16:22:01 DEBUG:  found parent 3
2001-05-22 16:22:01 DEBUG:  child is 3, parent is 1
2001-05-22 16:22:01 DEBUG:  found parent 4
2001-05-22 16:22:01 DEBUG:  child is 4, parent is 1
2001-05-22 16:22:01 DEBUG:  found parent 2
2001-05-22 16:22:01 DEBUG:  child is 2, parent is 1
2001-05-22 16:22:01 DEBUG:  found parent 1

But if "rec" is declared as "hierarchy%ROWTYPE", then
execution fails with such log messages:

2001-05-22 16:11:21 DEBUG:  child is 5, parent is 10
2001-05-22 16:11:21 DEBUG:  found parent 3
2001-05-22 16:11:21 DEBUG:  child is 3, parent is 10
Server process (pid 62170) exited with status 139 at Tue May 22 16:11:21
2001
Terminating any active server processes...
Server processes were terminated at Tue May 22 16:11:21 2001
Reinitializing shared memory and semaphores
....

Is this bug or feature?

Alexander Zagrebin
--


Responses

pgsql-bugs by date

Next:From: Brent EwingDate: 2001-05-22 22:57:08
Subject: repeated pointless memmove() calls in pqReadData()
Previous:From: Bruce MomjianDate: 2001-05-22 11:38:49
Subject: Re: Comments on Database Broken

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