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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | GH | 2000-11-15 05:29:39 | Database privileges |
Previous Message | ghaverla | 2000-11-15 01:48:47 | Re: converting seconds since epoch to time string |