Re: Using the extract() function in plpgsql
От | Kristis Makris |
---|---|
Тема | Re: Using the extract() function in plpgsql |
Дата | |
Msg-id | 200106272051.f5RKpEa87653@postgresql.org обсуждение исходный текст |
Ответ на | Re: Using the extract() function in plpgsql (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-sql |
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 ?
В списке pgsql-sql по дате отправления: