-----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 [EMAIL PROTECTED]
=========================================================== 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-----
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
