Re: [GENERAL] corrupted table postgresql 8.3

2012-03-07 Thread Matteo Sgalaberni
- Original Message - > I mostly agree, but it's possible you got hit by a fixed bug. I'm lucky ;) someone know how I can correct the catalog and drop the old/renamed table? Or probably is simpler: - pg_dump database - DROP database - CREATE DATABASE - psql database < dump Or do I need t

Re: [GENERAL] corrupted table postgresql 8.3

2012-03-07 Thread Merlin Moncure
On Tue, Mar 6, 2012 at 6:34 PM, Matteo Sgalaberni wrote: > - Original Message - >> On 6.3.2012 21:24, Matteo Sgalaberni wrote: >> > Hi people! >> > >> > I have a pg 8.3. Today I issued in a database that comand: >> >> Which minor version? The last one in this branch is 8.3.18 and if >> you

Re: [GENERAL] corrupted table postgresql 8.3

2012-03-06 Thread Matteo Sgalaberni
- Original Message - > On 6.3.2012 21:24, Matteo Sgalaberni wrote: > > Hi people! > > > > I have a pg 8.3. Today I issued in a database that comand: > > Which minor version? The last one in this branch is 8.3.18 and if > you're > running an old one, there might be an important bugfix ...

Re: [GENERAL] corrupted table postgresql 8.3

2012-03-06 Thread Tomas Vondra
On 6.3.2012 21:24, Matteo Sgalaberni wrote: > Hi people! > > I have a pg 8.3. Today I issued in a database that comand: Which minor version? The last one in this branch is 8.3.18 and if you're running an old one, there might be an important bugfix ... > =# ALTER TABLE cliente ADD COLUMN pwd_expi

[GENERAL] corrupted table postgresql 8.3

2012-03-06 Thread Matteo Sgalaberni
Hi people! I have a pg 8.3. Today I issued in a database that comand: =# ALTER TABLE cliente ADD COLUMN pwd_expired boolean DEFAULT FALSE; WARNING: unexpected attrdef record found for attr 22 of rel cliente WARNING: unexpected attrdef record found for attr 22 of rel cliente WARNING: unexpected