Re: Re: pg_dumpall failed

From: Oleg Lebedev <olebedev(at)waterford(dot)org>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Re: pg_dumpall failed
Date: 2001-08-30 21:53:58
Message-ID: 3B8EB5F6.ECAADB13@waterford.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Daniel Bakken 2001-08-30 21:54:18 BLOBs
Previous Message Oleg Lebedev 2001-08-30 20:20:21 Re: Re: pg_dumpall failed

Browse pgsql-sql by date

  From Date Subject
Next Message Oleg Lebedev 2001-08-30 22:53:10 Re: Re: pg_dumpall failed
Previous Message Marc André Paquin 2001-08-30 20:25:41 2 tables, joins and same name...