Hi everybody,
I have just installed PostgreSQL 6.5 and encountered problems with
PL/pgsql: On an insert into a table which has a before-insert trigger
I get the following error message:
ERROR: Load of file /usr/local/pgsql/lib/plpgsql.so failed:
/usr/local/pgsql/lib/plpgsql.so:
undefined symbol: SPI_push
What's wrong with my installation?
The trigger looks like this:
DECLARE
content CONSTANT VARCHAR (1) DEFAULT 'N';
new_series art.series%TYPE;
new_rating art.rating%TYPE;
anzahl INT4;
max_indx art.indx%TYPE;
BEGIN
new_series := NEW.series;
new_rating := NEW.rating;
SELECT COUNT (*)
INTO anzahl
FROM series
WHERE ke_content = content
AND series = new_series;
IF anzahl = 0 THEN
SELECT NVL (MAX (indx), 0) + 1
INTO max_indx
FROM series;
INSERT INTO series (ke_content, series, indx, rating)
VALUES (content, new_series, max_indx, new_rating);
END IF;
RETURN NEW;
END;
--
Oliver Graf
Oberhofstr. 11
D-44575 Castrop-Rauxel, Germany
Phone: +49 2305 14230
http://www.ruhr.de/home/casbah/
