Re: Table Drop Error

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Table Drop Error
Дата
Msg-id 10223d001b83afa185f5ec689b0cc6591c3fa15f.camel@cybertec.at
обсуждение исходный текст
Ответ на RE: Table Drop Error  (<soumik.bhattacharjee@kpn.com>)
Ответы RE: Table Drop Error  (<soumik.bhattacharjee@kpn.com>)
Список pgsql-admin
soumik.bhattacharjee@kpn.com wrote:
> From: Tom Lane <tgl@sss.pgh.pa.us> 
> > <soumik.bhattacharjee@kpn.com> writes:
> > > # delete from pg_depend where objid=49179; DELETE 0 # delete from 
> > > pg_depend where objid=49179; DELETE 0 # DROP TABLE caprimeta.tcr_codes 
> > > CASCADE;
> > > ERROR:  cache lookup failed for relation 49179
> >
> > It's not really a great idea to go dropping catalog rows without knowing exactly what you're doing, which I gather
youdon't.
 
> > However ... are there pg_depend entries with refobjid=49179 ?
> 
> Thanks for the mail, there is no entries in pg_depend as it returns " DELETE 0"
> But the table is not getting dropped.

Please read again.  "refobjid=49179", not "objid=49179".

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com



В списке pgsql-admin по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: pg_restore fails to restore sequence of specific table
Следующее
От: Mariel Cherkassky
Дата:
Сообщение: Re: pg_restore fails to restore sequence of specific table