pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Aaron Craig <mercutio@pobox.com>
To: pgsql-admin@postgresql.org
Subject: Re: Trouble using plpgsql after 8.0 install
Date: Tue, 01 Mar 2005 12:25:24 +0100
Message-ID: <42245124.7080004@pobox.com> (raw)
In-Reply-To: <4222521F.5090309@pobox.com>
References: <4222521F.5090309@pobox.com>

-----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&amp;id=0&amp;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-----



view thread (3+ messages)

Message-ID: <42245124.7080004@pobox.com>
Permalink:  ../42245124.7080004@pobox.com/
Also on:    postgresql.org/message-id/42245124.7080004@pobox.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: mercutio@pobox.com
  Subject: Re: Trouble using plpgsql after 8.0 install
  In-Reply-To: <42245124.7080004@pobox.com>
  References: <4222521F.5090309@pobox.com> <42245124.7080004@pobox.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox