pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Vic <vic@dcc.dp.ua>
To: pgsql-novice@postgresql.org
To: pgsql-interfaces@postgresql.org
Subject: Pl/Sql Error (may be..... )
Date: Sat, 11 Nov 2000 05:31:22 +0200
Message-ID: <3A0CBD8A.B349C042@dcc.dp.ua> (raw)

  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@ses:~ > pslq
stoage                                                   
bash: pslq: command not
found                                              
pvic@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)

Message-ID: <3A0CBD8A.B349C042@dcc.dp.ua>
Permalink:  ../3A0CBD8A.B349C042@dcc.dp.ua/
Also on:    postgresql.org/message-id/3A0CBD8A.B349C042@dcc.dp.ua

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: vic@dcc.dp.ua, pgsql-novice@postgresql.org
  Subject: Re: Pl/Sql Error (may be..... )
  In-Reply-To: <3A0CBD8A.B349C042@dcc.dp.ua>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox