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

Re: Relation missing?

From: "A B" <gentosaker(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Relation missing?
Date: 2008-05-13 13:43:52
Message-ID: dbbf25900805130643q29aaf700jaafc419284d77810@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
In this function I create no table, I just do insert into various
already existing tables.
It is not a prepared statement, but a function I created, so I'm not
sure if EXECUTE is what I should use.
This function has successfully run many times before, over several days.

Excuse my ignorance, but what is DDL commands? Is that like creating tables?


2008/5/13 A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com>:
> 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
>
>  --
>  Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
>  To make changes to your subscription:
>  http://www.postgresql.org/mailpref/pgsql-novice
>

In response to

Responses

pgsql-novice by date

Next:From: A. KretschmerDate: 2008-05-13 13:53:27
Subject: Re: Relation missing?
Previous:From: A. KretschmerDate: 2008-05-13 13:38:15
Subject: Re: Relation missing?

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