The following bug has been logged online:

Bug reference: 1246
Logged by: Christian Gonzalez

Email address: christiangda (AT) sigisweb (DOT) net

PostgreSQL version: 7.4.3

Operating system: Redhat 9 and Redhat EL 3

Description: not exist pltcl.so in postgresql rpm package

Details:

Hi,

I am trying to migrating to PostgreSQL 7.4.5 from 7.4.2, but I have a
problem with pltcl.so library.

I am finding this library on rpm package of PostgreSQL 7.4.5 and does exist.

Where I can find the pltcl.so library?...

I am migrating using a dump/restore.

Thanks in advance.

Best regards.


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

"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:
Should be in the postgresql-pl RPM.

regards, tom lane

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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Wed, 8 Sep 2004, "PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org>
wrote:

[devrim@devrim devrim]$ rpm -ql postgresql-pl|grep pltcl.so
/usr/lib/pgsql/pltcl.so

It's in the postgresql-pl rpm.

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFBP2DYtl86P3SPfQ4RAj53AJ485JTifpH/sJijaXKSa0CRhSaBHwCgt0sO
ajC1sTPOVdCeNBDU4bjSIDg=
=ZAN9
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Hi Tom,

The problem is into postgresql-pl.

I downloaded all rpm package for RedHat 9 and rhel3 from the postgresql.org
site.

For redhat 9:
-rw-r--r-- 1 root root 787 Sep 7 11:19 MD5SUM
-rw-r--r-- 1 root root 2037638 Sep 7 11:20
postgresql-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 439688 Sep 7 11:20
postgresql-contrib-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 17284615 Sep 7 11:22
postgresql-debuginfo-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 1763204 Sep 7 11:22
postgresql-devel-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 1239746 Sep 7 11:22
postgresql-docs-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 707019 Sep 7 11:22
postgresql-jdbc-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 142488 Sep 7 11:22
postgresql-libs-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 362000 Sep 7 11:22
postgresql-pl-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 38839 Sep 7 11:22
postgresql-python-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 3162539 Sep 7 11:23
postgresql-server-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 1054430 Sep 7 11:23
postgresql-test-7.4.5-1PGDG.i686.rpm

For rhel3
-rw-r--r-- 1 root root 787 Sep 7 11:23 MD5SUM
-rw-r--r-- 1 root root 2036384 Sep 7 11:23
postgresql-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 439392 Sep 7 11:23
postgresql-contrib-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 8086921 Sep 7 11:24
postgresql-debuginfo-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 917819 Sep 7 11:25
postgresql-devel-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 1193655 Sep 7 11:25
postgresql-docs-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 707040 Sep 7 11:25
postgresql-jdbc-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 142257 Sep 7 11:25
postgresql-libs-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 363493 Sep 7 11:25
postgresql-pl-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 38920 Sep 7 11:25
postgresql-python-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 3159511 Sep 7 11:26
postgresql-server-7.4.5-1PGDG.i686.rpm
-rw-r--r-- 1 root root 1054172 Sep 7 11:26
postgresql-test-7.4.5-1PGDG.i686.rpm

and when I execute "rpm -qpl postgresql-pl-7.4.5-1PGDG.i686.rpm" for both,
my output command is:

/usr/lib/pgsql/plperl.so
/usr/lib/pgsql/plpython.so

the plctl.so doesn't exist.

Regards, Christian Gonzalez


-----Mensaje original-----
De: Tom Lane [mailto:tgl (AT) sss (DOT) pgh.pa.us]
Enviado el: Miércoles, 08 de Septiembre de 2004 03:37 p.m.
Para: Christian Gonzalez
CC: pgsql-bugs (AT) postgresql (DOT) org
Asunto: Re: [BUGS] BUG #1246: not exist pltcl.so in postgresql rpm
package


"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:
Should be in the postgresql-pl RPM.

regards, tom lane


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match