Обсуждение: Re: [SQL] HELP: Trend reporting
Hi, I am trying to upgrade to 7.1.2 and when I use: pg_dumpall -o > file.bac I get an error saying: dumpRules(): SELECT failed for table setmedias. Explanation from backend: 'ERROR: cache lookup of attribute 5 in relation 23945 failed" As I understand setmedias table corresponds to relation 23945, but I dropped it a long time ago. How should remove this relation pointer? thanks, Oleg
On Thu, 30 Aug 2001, Oleg Lebedev wrote: > Hi, > I am trying to upgrade to 7.1.2 and when I use: > pg_dumpall -o > file.bac > I get an error saying: > dumpRules(): SELECT failed for table setmedias. Explanation from backend: > 'ERROR: cache lookup of attribute 5 in relation 23945 failed" > > As I understand setmedias table corresponds to relation 23945, but I dropped > it a long time ago. How should remove this relation pointer? > thanks, It sounds like you have a rule that still refers to the dead table.
I can't find any reference to this table in my current database. What's the best way to find this out? thank you, Oleg Stephan Szabo wrote: > On Thu, 30 Aug 2001, Oleg Lebedev wrote: > > > Hi, > > I am trying to upgrade to 7.1.2 and when I use: > > pg_dumpall -o > file.bac > > I get an error saying: > > dumpRules(): SELECT failed for table setmedias. Explanation from backend: > > 'ERROR: cache lookup of attribute 5 in relation 23945 failed" > > > > As I understand setmedias table corresponds to relation 23945, but I dropped > > it a long time ago. How should remove this relation pointer? > > thanks, > > It sounds like you have a rule that still refers to the dead table.
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.
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.