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 A6C91564C7 for ; Tue, 1 Mar 2005 11:28: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 13814-06 for ; Tue, 1 Mar 2005 11:27:51 +0000 (GMT) Received: from vsmtp4.tin.it (vsmtp4.tin.it [212.216.176.224]) by svr1.postgresql.org (Postfix) with ESMTP id 55D7256525 for ; Tue, 1 Mar 2005 11:27:50 +0000 (GMT) Received: from [192.168.0.2] (82.51.57.79) by vsmtp4.tin.it (7.0.027) (authenticated as aaron_craig@virgilio.it) id 421A54D8003531AA for pgsql-admin@postgresql.org; Tue, 1 Mar 2005 12:27:51 +0100 Message-ID: <42245124.7080004@pobox.com> Date: Tue, 01 Mar 2005 12:25:24 +0100 From: Aaron Craig User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Trouble using plpgsql after 8.0 install References: <4222521F.5090309@pobox.com> In-Reply-To: <4222521F.5090309@pobox.com> X-Enigmail-Version: 0.89.5.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: 200503/5 X-Sequence-Number: 16503 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Embarassingly, I realize that I should have actually shut down and restarted the server before complaining that the install didn't work. Having shut down the machine for the night, I discovered that the problem disappeared when I restarted the machine the next day. Shouldn't the rpm handle restarting the service after install though? Aaron Craig wrote: - -=-=- There is nothing either good or bad but thinking makes it so - -=-=- | 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. | - ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings - -- Aaron Craig mercutio@pobox.com =========================================================== Get Firefox! http://www.spreadfirefox.com/?q=affiliates&id=0&t=1 =========================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3-nr1 (Windows 2000) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCJFEkoyEQRcU83p4RAq6xAJ90GnRuLQccQpx5DuFCqKU1EpfZMACgjfPZ RnLTHEFBx4vkuSDVy3phdHg= =z/WP -----END PGP SIGNATURE-----