From: | Bharath Seshadri <sbharath(at)MSTI-India(dot)Com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | RelationForgetRelation error in postgres 7.2.2 |
Date: | 2003-04-22 10:00:16 |
Message-ID: | Pine.LNX.4.21.0304220447040.29954-100000@action.msti-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello,
I am using the version of postgres that is shipped with RedhatLinux
8.0 i.e version 7.2.2
My system details:
output of uname -a
Linux godavari.mpisoft-india.com 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002
i686 i686 i386 GNU/Linux
I am facing problems while executing stored procedures
There are 2 cases where postgres is giving errors and I am not able to get
documentation to correct the problem
Case 1:
I get an error when I execute a procedure which contains the statement
EXECUTE ''CREATE TABLE ''||tblcolldata||
'' (rank smallint,
funccode smallint,
cid integer,
slno integer)'';
/******************************************
The actual sql statement that gets executed is
CREATE TABLE colldata_1 (rank smallint,
funccode smallint,
cid integer,
slno integer)
*******************************************/
The error is
NOTICE: Error occurred while executing PL/pgSQL function match_collective
NOTICE: line 125 at SQL statement
filedbwriter ---> ERROR: RelationForgetRelation: relation 92539 is still
open
filedbwriter ---> status PGRES_FATAL_ERROR
Case 2:
I get an error when I execute a procedure which contains the statement
EXECUTE ''INSERT into ''||matchtblname||
'' SELECT ''||tblidsendcnt||''.id as sendid, ''||
tblidrecvcnt||''.id as recvid
from ''||tblidsendcnt||'', ''||tblidrecvcnt||
'' where ''||tblidsendcnt||''.sendcount = ''||
tblidrecvcnt||''.recvcount '';
/******************************************
The actual sql statement that gets executed is
INSERT into matched_sendrecv_1
SELECT idsendcnt_1.id as sendid,idrecvcnt_1.id as recvid
from idsendcnt_1, idrecvcnt_1
where idsendcnt_1.sendcount = idrecvcnt_1.recvcount ;
*******************************************/
The error is
NOTICE: Error occurred while executing PL/pgSQL function match_sendrecv
NOTICE: line 320 at SQL statement
filedbwriter ---> ERROR: RelationForgetRelation: relation 50506 is still
open
filedbwriter ---> status PGRES_FATAL_ERROR
-----------------------------------
The above mentioned errors do not show up in the latest version of
postgres i.e 7.3.2 when installed on Redhat 8.0 machine.
Was this a bug that was fixed?
Please respond.
Sincerely,
bharath
From | Date | Subject | |
---|---|---|---|
Next Message | A.Bhuvaneswaran | 2003-04-22 12:20:47 | Re: trouble creating trigger |
Previous Message | Christopher Kings-Lynne | 2003-04-22 08:33:27 | Re: [SQL] Yet Another (Simple) Case of Index not used |