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

Re: Relation missing?

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Relation missing?
Date: 2008-05-13 13:38:15
Message-ID: 20080513133815.GG25663@a-kretschmer.de (view raw or flat)
Thread:
Lists: pgsql-novice
am  Tue, dem 13.05.2008, um 15:08:51 +0200 mailte A B folgendes:
> I got an error
> 
> SELECT ERecord(100, 3492,'2008-05-13 10:25:57', 1, 0);
> 
> gave me (translating into english)
> 
> ERROR:  relation with OID 31330 doesn't exist
> CONTEXT:  SQL-statement: "INSERT INTO eLog (customer,shop,event,time)
> VALUES ( $1 , $2 , $3 , $4 )"
> PL/pgSQL function "erecord" line 5 at SQL statement
> 
> ERecord is a function written in PL/pgSQL... so what can this mean?

Wild gues: within this function you create this table and you don't use
EXECUTE for that. When you start a new session, the first time yout
function works fine, but the second call fails. Right?

PG caches the plan and the OID's for objects, because this fact it fails
the second time. To prevent this, use EXECUTE for all DDL-commands.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

In response to

Responses

pgsql-novice by date

Next:From: A BDate: 2008-05-13 13:43:52
Subject: Re: Relation missing?
Previous:From: A BDate: 2008-05-13 13:08:51
Subject: Relation missing?

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