LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 10-20-2004, 01:58 AM   #1
vickr1z
Member
 
Registered: Mar 2004
Location: manila, philippines
Distribution: RH 7.3
Posts: 63

Rep: Reputation: 15
PL/pgSQL anyone?


good day to all.

im installing plpgsql to my postgres database but i have encountered some error.
here's what i did to my interactive postgres terminal:

Code:
polmap=# CREATE FUNCTION plpgsql_call_handler () RETURNS language_handler
polmap--#       AS '$libdir/plpgsql', 'plpgsql_call_handler'
polmap--#       LANGUAGE C;
NOTICE:    ProcedureCreate:   type language_handler is not yet defined
(waiting for sometime.. )
CREATE FUNCTION

polmap=# CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler
polmap--#       LANCOMPILER 'PL/pgSQL';
ERROR:     CreateProceduralLanguage:    function plpgsql_call_handler must call LANGUAGE_HANDLER
i dont know what this mean. can any body help me how to correct and solve my problem?
thanks in advance..
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Nothing after rc.pgsql in rc.M starts karlmdv Slackware 4 04-04-2005 04:44 PM
gmake / building pgsql towlie Slackware 4 01-14-2005 10:30 PM
Path to Pgsql from perl help devinWhalen Linux - Software 0 02-11-2004 11:43 AM
Pgsql or mysql? other? Raspis21 Linux - Software 13 11-14-2003 11:25 PM
Dates in PL/PGSQL anisbet Linux - General 0 11-19-2001 11:16 AM


All times are GMT -5. The time now is 10:44 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration