On 8/3/06, Jonathan Vallar <bamvallar.db@gmail.com> wrote:
> Hi!
>
> I have a corrupt database that runs on Postgres 7.1.2. I was able to repair
> the database where I can now connect to the database and do queries.
>
> I have a migration plan to transfer my database to a Postgres 8.1. I
> encountered problems when I was dumping the database. Postgres 7.1 reported:
> getTables(): SELECT (funcname) for trigger trig_mis_t_ins returned 0 tuples.
> Expected 1.
>
> The trig_mis_t_ins trigger is no longer found on the database but it is
> still listed at the database. With this, I assume the database is corrupt.
>
> Would my problems go away if I dump it on postgres 8?
>
> Thanks.
>
> Regards,
>
> Jonathan
>
the better yu can do is try to dump the database with the 8.1's
pg_dump... but i don't know what problems can be (or if there is a
problem doing that)...
the better we can do is to wish you luck, your version is obsolete and
unsupported from some time ago...
--
regards,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook