| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | attila(dot)kuti(at)deepblue(dot)hu |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PGplSql: Relation 44451 does not exist |
| Date: | 2004-06-22 08:32:41 |
| Message-ID: | 40D7EEA9.4030807@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Kuti Attila wrote:
> Hi,
>
> I have a pgplsql function. It is quite short and simple.
>
> The problem:
>
> The following error message comes up for the SECOND time I call the it
> "Relation 44451 does not exist"
>
> In the function I create a temporary table, and at the end I drop it. There
> may be problem with this ? I don't know.
Plpgsql is compiled, so it refers to tables via their OID. The second
time around Tmembers has a different OID and so you get your error message.
The solution is to use the EXECUTE construct when accessing the table,
or to use an interpreted language (e.g. pltcl).
HTH
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2004-06-22 08:33:23 | Re: PGplSql: Relation 44451 does not exist |
| Previous Message | Scott Marlowe | 2004-06-22 08:13:44 | Do we need more emphasis on backup? |