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

Re: Relation missing?

From: Bruce Hyatt <brucejhyatt(at)yahoo(dot)com>
To: A B <gentosaker(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Relation missing?
Date: 2008-05-13 17:20:47
Message-ID: 530.93438.qm@web34401.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
DDL = Data Definition Language

I.e.; CREATE, ALTER and DROP statements.

Bruce

--- A B <gentosaker(at)gmail(dot)com> wrote:

> 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
> >
> 
> -- 
> 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

pgsql-novice by date

Next:From: Greg CocksDate: 2008-05-13 17:26:43
Subject: Re: Disadvantages to using "text" [ArcGIS]
Previous:From: Kasia TuszynskaDate: 2008-05-13 17:04:08
Subject: Re: Disadvantages to using "text"

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