pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kristis Makris <kristis.makris@datasoft.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Richard Huxton <dev@archonet.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Using the extract() function in plpgsql
Date: 27 Jun 2001 13:51:07 -0700
Message-ID: <200106272051.f5RKpEa87653@postgresql.org> (raw)
In-Reply-To: <13712.993672268@sss.pgh.pa.us>
References: <200106202233.f5KMXSa91452@postgresql.org>
	<003701c0fa5e$722570a0$1001a8c0@archonet.com>
	<200106261958.f5QJwsa45412@postgresql.org>
	<3B398892.D0001CDE@archonet.com>
	<200106271556.f5RFu4a53609@postgresql.org>
	<3B3A265E.E13F3944@archonet.com>
	<13712.993672268@sss.pgh.pa.us>

On 27 Jun 2001 16:04:28 -0400, Tom Lane wrote:
> Richard Huxton <dev@archonet.com> writes:
> > 2. bad oid reference - even if we did recreate the table, the reference
> > to it is compiled in after the first run. Don't see a way around this one.
> 
> You could work around that by making all the queries referencing the
> temp table be built up as strings and EXECUTE'd, rather than just
> writing them in-line in the plpgsql code.  Pretty grotty but it might
> serve for now.  Eventually plpgsql needs to have a way to discard
> query plans that have been obsoleted by DDL changes.
> 
>                       regards, tom lane


Good point, but this approach might not be able to handle all the
queries required to be executed. In particular the EXECUTE of SELECT ...
INTO is not implemented yet, as of Postgres 7.1.2. Any thoughts on when
this feature will be implemented? 7.1.x ? 7.x ?




view thread (11+ messages)

Message-ID: <200106272051.f5RKpEa87653@postgresql.org>
Permalink:  ../200106272051.f5RKpEa87653@postgresql.org/
Also on:    postgresql.org/message-id/200106272051.f5RKpEa87653@postgresql.org

 · 

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: kristis.makris@datasoft.com, tgl@sss.pgh.pa.us, dev@archonet.com
  Subject: Re: Using the extract() function in plpgsql
  In-Reply-To: <200106272051.f5RKpEa87653@postgresql.org>

* 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