From: | Oleg Lebedev <olebedev(at)waterford(dot)org> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Re: pg_dumpall failed |
Date: | 2001-08-30 22:53:10 |
Message-ID: | 3B8EC3D6.8288123A@waterford.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jouji Miwa | 2001-08-31 03:12:15 | automatical start of postmaster for Windows2000 |
Previous Message | Daniel Bakken | 2001-08-30 21:54:18 | BLOBs |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-08-30 22:53:51 | Re: Sql |
Previous Message | Oleg Lebedev | 2001-08-30 21:53:58 | Re: Re: pg_dumpall failed |