| From: | Tim Uckun <tim(at)diligence(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | VIEW problem |
| Date: | 2000-10-05 06:24:41 |
| Message-ID: | 4.2.0.58.20001004232131.01324790@mail.diligence.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
This sequence of events seems to break something.
1) Create table foo
2) create table bar
3) create view foobar linking the two tables.
4) drop table foo
5) Create table foo (identical to first table)
6) SELECT from view foobar.
step six causes a relation not found error.
Is this a bug? As long as the SQL statement that the view is based on is
still valid why does it care if the table is dropped and recreated?
----------------------------------------------
Tim Uckun
Mobile Intelligence Unit.
----------------------------------------------
"There are some who call me TIM?"
----------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-10-05 06:31:23 | Re: CIDR index use for '<<' operator |
| Previous Message | Tom Lane | 2000-10-05 06:20:56 | Re: executing user-defined functions |