| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "L(dot) Fletcher" <lucasf(at)vagabond-software(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: basic temp table question |
| Date: | 2005-03-02 00:38:04 |
| Message-ID: | 3044.1109723884@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"L. Fletcher" <lucasf(at)vagabond-software(dot)com> writes:
> I get this error:
> ERROR: XX000: relation 1090457025 is still open
This is an 8.0 bug fixed in 8.0.1.
> All subsequent times I get this error:
> ERROR: 42P01: relation with OID 1090457025 does not exist=20
This is because plpgsql caches plans and therefore can't cope with
tmp_table not being the identical same table from run to run of the
function. Sooner or later we will probably fix that, but in the
meantime consider using an ON COMMIT DELETE ROWS temp table, created
only once per connection, instead.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Frankel | 2005-03-02 00:51:24 | Re: sql join question |
| Previous Message | L. Fletcher | 2005-03-02 00:06:48 | basic temp table question |