X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 89E1E563A6 for ; Sun, 27 Feb 2005 23:05:01 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61262-10 for ; Sun, 27 Feb 2005 23:04:45 +0000 (GMT) Received: from vsmtp4.tin.it (vsmtp4.tin.it [212.216.176.224]) by svr1.postgresql.org (Postfix) with ESMTP id 8525F52A85 for ; Sun, 27 Feb 2005 23:04:50 +0000 (GMT) Received: from [192.168.0.4] (82.51.57.79) by vsmtp4.tin.it (7.0.027) (authenticated as aaron_craig@virgilio.it) id 421A54D8002A8A6B for pgsql-admin@postgresql.org; Mon, 28 Feb 2005 00:05:03 +0100 Message-ID: <4222521F.5090309@pobox.com> Date: Mon, 28 Feb 2005 00:05:03 +0100 From: Aaron Craig User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Trouble using plpgsql after 8.0 install X-Enigmail-Version: 0.90.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200502/320 X-Sequence-Number: 16488 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I've just upgraded to 8.01 on a Fedora 3 machine by doing the following yum remove postgresql-* and then (having previously downloaded these packages from my local FTP mirror) postgresql-8.0.1-2PGDG.i686.rpm postgresql-contrib-8.0.1-2PGDG.i686.rpm postgresql-devel-8.0.1-2PGDG.i686.rpm postgresql-docs-8.0.1-2PGDG.i686.rpm postgresql-jdbc-8.0.1-2PGDG.i686.rpm postgresql-libs-8.0.1-2PGDG.i686.rpm postgresql-pl-8.0.1-2PGDG.i686.rpm postgresql-server-8.0.1-2PGDG.i686.rpm postgresql-test-8.0.1-2PGDG.i686.rpm yum install postgresql-* After removing the devel package from the group (this gave me a dependency issue) I was able to successfully(?) install the new postgres. I then separately installed the devel package. However, when I: su - postgres psql some_database select get_booked_show(1, '20050101'); I get this result: ERROR: could not load library "/usr/lib/pgsql/plpgsql.so": /usr/lib/pgsql/plpgsql.so: undefined symbol: PG_exception_stack The get_booked_show function is defined thusly: CREATE FUNCTION get_booked_show(INTEGER, TIMESTAMP) RETURNS INTEGER AS ' ~ DECLARE ~ evt_id ALIAS FOR $1; ~ showtime ALIAS FOR $2; ~ r_return RECORD; ~ BEGIN ~ SELECT INTO r_return SUM(seats) AS seat_count ~ FROM reservation ~ WHERE xdb_reservation_id In( ~ SELECT reservation FROM event_reservation WHERE event = evt_id) ~ AND reserve_datetime = showtime; ~ RETURN r_return.seat_count; ~ END;' LANGUAGE 'plpgsql'; I search on the postgres site for 'undefined symbol: PG_exception_stack' didn't turn up anything interesting, and a search on Google groups turned up a thread indicating that perhaps I'm trying to call a pre 8.0 .so from the 8.0 front-end. However, wouldn't all of the 7.4 stuff have been removed by my yum remove call? Any insight is greatly appreciated. - -- Aaron Craig mercutio@pobox.com =========================================================== Get Firefox! http://www.spreadfirefox.com/?q=affiliates&id=0&t=1 =========================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCIlIeoyEQRcU83p4RAuo3AJ95tA2YZ8u1ug6pztry32f7LkaFNACcDciv POAIjxzb6yg8ODBbqv8hGUI= =EAC6 -----END PGP SIGNATURE-----