| From: | Francisco Reyes <lists(at)natserv(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Relation on longer exists error |
| Date: | 2002-05-07 02:09:58 |
| Message-ID: | 20020506220849.J78437-100000@zoraida.natserv.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 6 May 2002, Tom Lane wrote:
> Francisco Reyes <lists(at)natserv(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-05-07 02:26:10 | Re: time in 7.2 |
| Previous Message | Francisco Reyes | 2002-05-07 02:07:52 | Re: Problems with list? |