Re: Bug #956: plperl vs. plperlu

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