| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Oleg Lebedev <olebedev(at)waterford(dot)org> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Re: pg_dumpall failed |
| Date: | 2001-08-30 20:06:46 |
| Message-ID: | Pine.BSF.4.21.0108301305160.54588-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Lebedev | 2001-08-30 20:20:21 | Re: Re: pg_dumpall failed |
| Previous Message | Oleg Lebedev | 2001-08-30 20:02:47 | Re: Re: pg_dumpall failed |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Lebedev | 2001-08-30 20:20:21 | Re: Re: pg_dumpall failed |
| Previous Message | Oleg Lebedev | 2001-08-30 20:02:47 | Re: Re: pg_dumpall failed |