Re: pltlc and pltlcu problems

<pre><br />after i have succesfully used createlan script to load both the trusted and untrusted tlc languages i try
sometests<br /><br /><br />i create a test function (right out of the docs)<br /><br /><br />    CREATE FUNCTION
tcl_max(int4, int4) RETURNS int4 AS '    if {$1 > $2} {return $1}    return $2' LANGUAGE 'pltclu';
 

<br /><br />and i try to run this stest<br /><br />    select tcl_max(4,6);
<br />but i get<br /><br /><br />    ERROR:  fmgr_info: function 17020: cache lookup failed<br /><br />so i create
trustedversion<br /><br /><br />    CREATE FUNCTION tcl_max (int4, int4) RETURNS int4 AS '    if {$1 > $2} {return
$1}   return $2' LANGUAGE 'pltcl';<br /><br />and i again try to run this stest<br /><br />    select tcl_max(4,6);
 
<br />but i get instead<br /><br />    server closed the connection unexpectedly        This probably means the server
terminatedabnormally        before or while processing the request.connection to server was lost
 

<br />and if i look at the log<br /><br />postgres: murray kale [local] SELECT: error while loading shared libraries:
/usr/lib/postgresql/pltcl.so:undefined symbol: Tcl_CreateInterp<br />DEBUG:  server process (pid 18415) exited with
exitcode 127
 
DEBUG:  terminating any other active server processes
DEBUG:  all server processes terminated; reinitializing shared memory and semaphores
DEBUG:  database system was interrupted at 2002-01-19 15:01:29 EST
DEBUG:  checkpoint record is at 0/4BAD10
DEBUG:  redo record is at 0/4BAD10; undo record is at 0/0; shutdown TRUE
DEBUG:  next transaction id: 2120; next oid: 49324
DEBUG:  database system was not properly shut down; automatic recovery in progress
DEBUG:  redo starts at 0/4BAD50
DEBUG:  ReadRecord: record with zero length at 0/4C0FB4
DEBUG:  redo done at 0/4C0F90
DEBUG:  database system is ready<br /><br /><br />so what do i do now?<br /><br />log it as a bug?<br /><br /><br
/>murray<br/><br /><br /><br /></pre> so ok i go to the sources looking for test of pl/tlc or pl/tlcu (untrusted)<br
/><br/><br /><br /><br /><br /> Tom Lane wrote:<br /><blockquote cite="mid:6420.1011366281@sss.pgh.pa.us"
type="cite"><prewrap="">Murray Prior Hobbs <a class="moz-txt-link-rfc2396E"
href="mailto:murray@efone.com"><murray@efone.com></a>writes:<br /></pre><blockquote type="cite"><pre
wrap="">ERROR: Load of file /usr/lib/postgresql/pltcl.so failed: <br />/usr/lib/postgresql/pltcl.so: undefined symbol:
pg_get_enconv_by_encoding<br/></pre></blockquote><pre wrap=""><br />Looks like a multibyte-enabled pltcl and a
non-multibyte-enabled<br/>backend.  Given that they were clearly built at different times and<br />with different
configurations,one might also wonder if they're even<br />the same Postgres version.<br /><br />            regards,
tomlane<br /><br />---------------------------(end of broadcast)---------------------------<br />TIP 4: Don't 'kill -9'
thepostmaster<br /><br /></pre></blockquote><br /><br />