Skip site navigation (1) Skip section navigation (2)

Re: Corrupt view in PostgreSQL 9.0.9

From: Mikael Kjellström <mikael(dot)kjellstrom(at)mksoft(dot)nu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Corrupt view in PostgreSQL 9.0.9
Date: 2012-09-28 17:50:04
Message-ID: 5065E34C.7030109@mksoft.nu (view raw or flat)
Thread:
Lists: pgsql-bugs
On 2012-09-28 19:39, Tom Lane wrote:
> =?ISO-8859-1?Q?Mikael_Kjellstr=F6m?= <mikael(dot)kjellstrom(at)mksoft(dot)nu> writes:
>> Your recomendation is to restore the backup to a new database and drop
>> the old one, right?
>
> Right.  If you've got more than one active database in this
> installation, it might be prudent to dump and restore the whole thing
> --- but in any case, you don't want to trust this database's
> pg_attribute anymore.

Ok.  I've done just that.  I dumped the database, dropped it and then 
created it and restored the backup.  All the data seems to be there also 
at a first glance.

I also took the oppertunity to compile and upgrade to 9.0.10 when I had 
the chance.

Thanks for all the help.

/Mikael


In response to

pgsql-bugs by date

Next:From: mr.dash.fourDate: 2012-09-28 22:08:30
Subject: BUG #7575: "between" does not work properly with inet/cidr addresses
Previous:From: Tom LaneDate: 2012-09-28 17:39:38
Subject: Re: Corrupt view in PostgreSQL 9.0.9

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group