Re: Relation on longer exists error - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Relation on longer exists error
Date
Msg-id 20020506220849.J78437-100000@zoraida.natserv.net
Whole thread Raw
In response to Re: Relation on longer exists error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Mon, 6 May 2002, Tom Lane wrote:

> Francisco Reyes <lists@natserv.com> writes:
> > I have a script that I regularly run. Today when I ran it I got:
> > ERROR:  Relation "ystats" with OID 715717097 no longer exists
> > I did drop/recreate that table today, but what would I be getting this
> > error?
>
> I think you broke a rule or view that referenced that table.
>             regards, tom lane

It was 4 views.
I had never used views until this weekend.
I was unaware that if one drops a table one needs to recreate it's views.
Good thing that I I keep all my table/view definitions in script files.


pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Problems with list?
Next
From: Tom Lane
Date:
Subject: Re: time in 7.2