Skip site navigation (1) Skip section navigation (2)

Troubles with plPgSQL.

From: Vic <vic(at)dcc(dot)dp(dot)ua>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Troubles with plPgSQL.
Date: 2000-11-15 05:26:50
Message-ID: 3A121E9A.F586968E@dcc.dp.ua (view raw or flat)
Thread:
Lists: pgsql-novice
 I attach(create language) language PL/pgSQL in PG and
 create   test  function  (cut it from help ) :

 --Просто  склеить  строки в одну
     CREATE FUNCTION ct1(text, text) RETURNS text AS '
        BEGIN
            RETURN $1 || $2;
        END;
    ' LANGUAGE 'plpgsql';

So that  is  my  log :

pvic(at)ses:~ > pslq
stoage                                                   
bash: pslq: command not
found                                              
pvic(at)ses:~ > psql
storage                                                  
Welcome to the POSTGRESQL interactive sql
monitor:                         
  Please read the file COPYRIGHT for copyright terms of
POSTGRESQL         
[PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc
egcs-2.91.66]      
                                                                           
   type \? for help on slash
commands                                      
   type \q to
quit                                                         
   type \g or terminate with semicolon to execute
query                    
 You are currently connected to the database:
storage                      
                                                                           
storage=> select
ct1('ddd','ddd');                                         
ERROR:  plpgsql: cache lookup from pg_proc
failed                                       

Can  anyone tell me  how  correct  this  error and/or its  my  mistake
or PG bug ? 

Thanks in advance.

 Vic (AKA MorDoor)

pgsql-novice by date

Next:From: GHDate: 2000-11-15 05:29:39
Subject: Database privileges
Previous:From: ghaverlaDate: 2000-11-15 01:48:47
Subject: Re: converting seconds since epoch to time string

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group