| Lists: | pgsql-bugs |
|---|
| From: | "chris wood" <chrisj(dot)wood(at)sympatico(dot)ca> |
|---|---|
| To: | <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | was enhancement of temp tables in plpgsql supposed to apply to temp views as well? appears it did not. |
| Date: | 2007-11-28 22:32:26 |
| Message-ID: | 006201c8320e$8d555590$6700a8c0@D7F27961 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
Plpgsql procedure:
BEGIN
Drop table if exits temptable cascade ;
Create temp table temptable ...
Create temp view tempview as select . from temptable...
Select .. from tempview ...
END
The first time I run this after I create the procedure it works perfectly.
The second time I get notices that the drop is cascading to the view (this
was expected and OK)
But then the select fails
ERROR: could not open relation .. No such file or directory
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "chris wood" <chrisj(dot)wood(at)sympatico(dot)ca> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: was enhancement of temp tables in plpgsql supposed to apply to temp views as well? appears it did not. |
| Date: | 2007-11-28 23:11:27 |
| Message-ID: | 25558.1196291487@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
"chris wood" <chrisj(dot)wood(at)sympatico(dot)ca> writes:
> Plpgsql procedure:
Would you provide a self-contained test case, rather than a handwavy
description? It certainly should work, so I suppose there is some
critical point that you left out.
Also, you *are* testing 8.3something, right? What exactly?
regards, tom lane