Received: from mail1.waterford.org (mail1.waterford.org [205.124.117.6]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7UMa4f11363 for ; Thu, 30 Aug 2001 18:36:04 -0400 (EDT) (envelope-from olebedev@waterford.org) Received: from waterford.org ([205.124.117.198]) by mail1.waterford.org (Netscape Messaging Server 3.56) with ESMTP id 613; Thu, 30 Aug 2001 16:27:38 -0600 Message-ID: <3B8EC3D6.8288123A@waterford.org> Date: Thu, 30 Aug 2001 16:53:10 -0600 From: Oleg Lebedev X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: Stephan Szabo , pgsql-admin@postgresql.org Subject: Re: Re: pg_dumpall failed References: <3B8EB5F6.ECAADB13@waterford.org> Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit X-Archive-Number: 200108/142 X-Sequence-Number: 2081 Thanks a lot Stephan, dropping the right rule solved the problem. Oleg Oleg Lebedev wrote: > I tried > select * from pg_rewrite where ev_class=23945; > No tuples were returned. > What should I do next? > thanks, > > Oleg > > Stephan Szabo wrote: > > > Oops, of course, the row in pg_class isn't there so > > the pg_rules view won't show it. > > > > Okay, try > > select * from pg_rewrite where ev_class=23945; > > > > On Thu, 30 Aug 2001, Oleg Lebedev wrote: > > > > > select * from pg_rules > > > returned NO tuples. > > > What should I do next? > > > thanks, > > > > > > Oleg > > > > > > Stephan Szabo wrote: > > > > > > > On Thu, 30 Aug 2001, Oleg Lebedev wrote: > > > > > > > > > I can't find any reference to this table in my current database. > > > > > What's the best way to find this out? > > > > > thank you, > > > > > > > > Try a > > > > select * from pg_rules; > > > > > > > > And see if any of the rule definitions mention the table. > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://www.postgresql.org/search.mpl > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster