pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: A. Kretschmer <andreas.kretschmer@schollglas.com>
To: pgsql-sql@postgresql.org
Subject: Re: hi may i know y am i getting this error
Date: Fri, 17 Nov 2006 12:07:16 +0100
Message-ID: <20061117110716.GH30411@a-kretschmer.de> (raw)
In-Reply-To: <A70AE049E81A6A40879D5DC0AC8C38C9078D7304@venus.infics.com>
References: <A70AE049E81A6A40879D5DC0AC8C38C9078D7304@venus.infics.com>

am  Fri, dem 17.11.2006, um 15:15:25 +0530 mailte Penchalaiah P. folgendes:
> Hi
> 
> When I am executing my function its giving error.. first time its running
> properly.. but when I am executing second time I am getting error
> 
> create or replace function irla_punching_medium_insert1(in_proj_code
> numeric,in_pt_code varchar,in_mon_abs date) returns varchar as'
> ...
> 
> create table dummy_table without oids as
>  
> ...
> 
> drop table dummy_table;
> end;
> 
> 'language'plpgsql';

PG caches the plan for this function and runs in an error, because it
believes the second time, that this table has the oid from the first
run.

You can rewrite your function and use EXECUTE for such statements
(create and drop table). This might be helpful, but i'm not sure.


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

view thread (3+ messages)

Message-ID: <20061117110716.GH30411@a-kretschmer.de>
Permalink:  ../20061117110716.GH30411@a-kretschmer.de/
Also on:    postgresql.org/message-id/20061117110716.GH30411@a-kretschmer.de

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: andreas.kretschmer@schollglas.com
  Subject: Re: hi may i know y am i getting this error
  In-Reply-To: <20061117110716.GH30411@a-kretschmer.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox