VIEW problem - Mailing list pgsql-general

From Tim Uckun
Subject VIEW problem
Date
Msg-id 4.2.0.58.20001004232131.01324790@mail.diligence.com
Whole thread Raw
List 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?"
----------------------------------------------

pgsql-general by date:

Previous
From: Nina Kuznetsova
Date:
Subject: undefined reference
Next
From: Tom Lane
Date:
Subject: Re: -F option, RAM usage, more...