From: Tom Lane <tgl@sss.pgh.pa.us>
To: Richard Huxton <dev@archonet.com>
Cc: Kristis Makris <kristis.makris@datasoft.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Using the extract() function in plpgsql
Date: Wed, 27 Jun 2001 16:04:28 -0400
Message-ID: <13712.993672268@sss.pgh.pa.us> (raw)
In-Reply-To: <3B3A265E.E13F3944@archonet.com>
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>
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
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: tgl@sss.pgh.pa.us, dev@archonet.com, kristis.makris@datasoft.com
Subject: Re: Using the extract() function in plpgsql
In-Reply-To: <13712.993672268@sss.pgh.pa.us>
* 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