Update from 7.3.3 to 7.3.6

[Mike Bell]

Hi,

We are in the process of moving from PostgreSQL 7.3.3 to 7.3.6 (Red
Hat). However, we are having a number of problems importing the database
schema. Some of the SPs are written in TCL and it would seem that the
library has changed.

In the dump of the schema we have (comments removed for brevity):

CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;

CREATE FUNCTION pltcl_call_handler () RETURNS language_handler
AS '$libdir/pltcl', 'pltcl_call_handler'
LANGUAGE c;

CREATE TRUSTED PROCEDURAL LANGUAGE pltcl HANDLER pltcl_call_handler;

However, when importing we get:

ERROR: stat failed on file '$libdir/pltcl': No such file or directory

What is the best way of sorting this out?

Cheers & TIA

Mike



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Tom Lane]

Post by Mike Bell
We are in the process of moving from PostgreSQL 7.3.3 to 7.3.6 (Red
Hat). However, we are having a number of problems importing the database
schema. Some of the SPs are written in TCL and it would seem that the
library has changed.
ERROR: stat failed on file '$libdir/pltcl': No such file or directory

Hmm. The most obvious question is did you remember to install the
postgresql-tcl RPM?

"pg_config --pkglibdir" will tell you what directory $libdir expands to,
and you can look in there to see if there's a pltcl.so or not. It
appears from the above that the answer will be "not".

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Mike Bell]

Tom,

Thanks for that.

It appears that the tcl support is there. However, the lib now appears
to be called:

./usr/lib/libpgtcl.so

Is this the same? I couldn't find documentation concerning the change in
file. If so then can I just edit the schema?

Cheers

Mike

-----Original Message-----
From: Tom Lane [mailto:***@sss.pgh.pa.us]
Sent: 09 August 2004 16:55
To: Mike Bell
Cc: pgsql-***@postgresql.org
Subject: Re: [ADMIN] Update from 7.3.3 to 7.3.6

Post by Mike Bell
We are in the process of moving from PostgreSQL 7.3.3 to 7.3.6 (Red
Hat). However, we are having a number of problems importing the database
schema. Some of the SPs are written in TCL and it would seem that the
library has changed.
ERROR: stat failed on file '$libdir/pltcl': No such file or directory

Hmm. The most obvious question is did you remember to install the
postgresql-tcl RPM?

"pg_config --pkglibdir" will tell you what directory $libdir expands to,
and you can look in there to see if there's a pltcl.so or not. It
appears from the above that the answer will be "not".

regards, tom lane



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org

[Tom Lane]

Post by Mike Bell
It appears that the tcl support is there. However, the lib now appears
./usr/lib/libpgtcl.so
Is this the same?

No, it's not the same at all. That is a client-side library.

[ digs in RPM specfile ... ] Oh, I misspoke. It looks like pltcl lives
in the postgresql-pl RPM. Did you install that one?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Mike Bell]

Yes, I believe so:

rpm -qa | grep -i postgresql

rh-postgresql-contrib-7.3.6-1_ts2.eduserv_1.rhel3
rh-postgresql-libs-7.3.6-1_ts2.eduserv_1.rhel3
rh-postgresql-tcl-7.3.6-1_ts2.eduserv_1.rhel3
rh-postgresql-devel-7.3.6-1_ts2.eduserv_1.rhel3
rh-postgresql-server-7.3.6-1_ts2.eduserv_1.rhel3
rh-postgresql-7.3.6-1_ts2.eduserv_1.rhel3
rh-postgresql-python-7.3.6-1_ts2.eduserv_1.rhel3
rh-postgresql-pl-7.3.6-1_ts2.eduserv_1.rhel3

Any other suggestions?

Cheers

Mike
-----Original Message-----
From: pgsql-admin-***@postgresql.org
[mailto:pgsql-admin-***@postgresql.org] On Behalf Of Tom Lane
Sent: 09 August 2004 17:31
To: Mike Bell
Cc: pgsql-***@postgresql.org
Subject: Re: [ADMIN] Update from 7.3.3 to 7.3.6

Post by Mike Bell
It appears that the tcl support is there. However, the lib now appears
./usr/lib/libpgtcl.so
Is this the same?

No, it's not the same at all. That is a client-side library.

[ digs in RPM specfile ... ] Oh, I misspoke. It looks like pltcl lives
in the postgresql-pl RPM. Did you install that one?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

[Tom Lane]

Post by Mike Bell
rpm -qa | grep -i postgresql
...
rh-postgresql-pl-7.3.6-1_ts2.eduserv_1.rhel3

That one should certainly have installed pltcl.so for you. Perhaps you
could use rpm -ql to find out where it put it?

I suspect that overall this is a problem of not having completely
replaced the old PG installation --- somehow you are picking up an
executable from the previous installation, or something like that.
But the exact problem isn't clear to me.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)