-----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 [EMAIL PROTECTED]
=========================================================== 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-----
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
