Re: Bug #956: plperl vs. plperlu - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #956: plperl vs. plperlu
Date
Msg-id 29387.1051370606@sss.pgh.pa.us
Whole thread Raw
In response to Bug #956: plperl vs. plperlu  (pgsql-bugs@postgresql.org)
Responses Re: Bug #956: plperl vs. plperlu
List pgsql-bugs
pgsql-bugs@postgresql.org writes:
> FYI, in 7.3.2, we are unable to create two languages viz, plperl and
> plperlu

Wups.  There is code in there to handle that case, but it got broken by
a last-minute 7.3 change.  Here's the patch.

            regards, tom lane


*** src/bin/scripts/createlang.sh~    Fri Oct 18 18:05:36 2002
--- src/bin/scripts/createlang.sh    Sat Apr 26 11:19:05 2003
***************
*** 256,262 ****
  # ----------
  # Check whether the call handler exists
  # ----------
! sqlcmd="SELECT oid FROM pg_proc WHERE proname = '$handler' AND prorettype = 0 AND pronargs = 0;"
  if [ "$showsql" = yes ]; then
      echo "$sqlcmd"
  fi
--- 256,262 ----
  # ----------
  # Check whether the call handler exists
  # ----------
! sqlcmd="SELECT oid FROM pg_proc WHERE proname = '$handler' AND prorettype = (SELECT oid FROM pg_type WHERE typname =
'language_handler')AND pronargs = 0;" 
  if [ "$showsql" = yes ]; then
      echo "$sqlcmd"
  fi

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #956: plperl vs. plperlu
Next
From: Chris Bowlby
Date:
Subject: pg_dump core dumping