Pltcl kills postmaster...

"Ian Harding" <ianh@healthdept.co.pierce.wa.us> writes:

However, any time I try to execute a pltcl function, I get

/usr/pkg/lib/pltcl.so: Undefined PLT symbol "TclCreateInterp" (reloc type=7, synum=3)
Server process (pid 11970) exited with status 256...

Looks like the backend is not finding the libtcl shared library for
some reason...

-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it strangled up my mind,
Now people just get uglier, and I got no sense of time... --Dylan

It is there, and has reasonable permissions (755). Hmmmm....

Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: ianh@tpchd.org

Doug McNaught <doug@wireboard.com> 06/01/01 12:18PM >>>

"Ian Harding" <ianh@healthdept.co.pierce.wa.us> writes:

However, any time I try to execute a pltcl function, I get

/usr/pkg/lib/pltcl.so: Undefined PLT symbol "TclCreateInterp" (reloc type=7, synum=3)
Server process (pid 11970) exited with status 256...

Looks like the backend is not finding the libtcl shared library for
some reason...

-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it strangled up my mind,
Now people just get uglier, and I got no sense of time... --Dylan

Ian Harding wrote:

NetBSD 1.5 on i386
PostgreSQL 7.1.1 and 7.1.2

I downloaded source, compiled and installed Postgresql 7.1.1 and all was well.

Once the NetBSD pkgsrc packages caught up with the latest distribution, I decided to use it to install and maintain PG. So, I deleted /usr/local/pgsql and installed using pgksrc. It seems to have worked fine.

I added 'pltcl' language to template1 and created a database. I created my tables, views, functions, triggers from script. Functions create just fine.

However, any time I try to execute a pltcl function, I get

/usr/pkg/lib/pltcl.so: Undefined PLT symbol "TclCreateInterp" (reloc type=7, synum=3)
Server process (pid 11970) exited with status 256...

What could this be?

What version of Tcl is that now?

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

tcl 8.3.

By the way, I found that libtcl83 is NOT there, but there is a libtcl83.a and some other extensions. It appears to be appending alphas and numbers as I have been thrashing around building and installing things. I wonder if this has something to do with it...

Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: ianh@tpchd.org

Jan Wieck <JanWieck@Yahoo.com> 06/01/01 12:51PM >>>

Ian Harding wrote:

NetBSD 1.5 on i386
PostgreSQL 7.1.1 and 7.1.2

I downloaded source, compiled and installed Postgresql 7.1.1 and all was well.

Once the NetBSD pkgsrc packages caught up with the latest distribution, I decided to use it to install and maintain PG. So, I deleted /usr/local/pgsql and installed using pgksrc. It seems to have worked fine.

I added 'pltcl' language to template1 and created a database. I created my tables, views, functions, triggers from script. Functions create just fine.

However, any time I try to execute a pltcl function, I get

/usr/pkg/lib/pltcl.so: Undefined PLT symbol "TclCreateInterp" (reloc type=7, synum=3)
Server process (pid 11970) exited with status 256...

What could this be?

What version of Tcl is that now?

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

A better understanding of the packages collection might help me. I commented out the line in the Makefile that says --without-tcl thinking that was what I needed to do to get pltcl to work. All it did was break it.

I ran 'make update' in the tcl package directory, and noticed that it installed postgresql-pltcl as well as tcl and tk. This fixed my problem.

I still don't know exactly why that broke it, but it's all better now.

Thanks!

Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: ianh@tpchd.org

Jan Wieck <JanWieck@Yahoo.com> 06/01/01 12:51PM >>>

Ian Harding wrote:

NetBSD 1.5 on i386
PostgreSQL 7.1.1 and 7.1.2

I downloaded source, compiled and installed Postgresql 7.1.1 and all was well.

Once the NetBSD pkgsrc packages caught up with the latest distribution, I decided to use it to install and maintain PG. So, I deleted /usr/local/pgsql and installed using pgksrc. It seems to have worked fine.

I added 'pltcl' language to template1 and created a database. I created my tables, views, functions, triggers from script. Functions create just fine.

However, any time I try to execute a pltcl function, I get

/usr/pkg/lib/pltcl.so: Undefined PLT symbol "TclCreateInterp" (reloc type=7, synum=3)
Server process (pid 11970) exited with status 256...

What could this be?

What version of Tcl is that now?

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com