Re: Relation on longer exists error

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Relation on longer exists error
Дата
Msg-id 20020506220849.J78437-100000@zoraida.natserv.net
обсуждение исходный текст
Ответ на Re: Relation on longer exists error  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Re: Problems with list?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: time in 7.2