Hi all. I use postgres to collect all information of my work.
Debian: 3.0r1 Version: 7.2.1 Libc: 2.2.5 I have change a table schema and since this Postgres has lost the definition of some table. That is. The database's name is 'dbore'. Inside I defined a table ore. The schema, since january 2003 was codprogetto: integer, ore: smallint. descrizione: text, data:date, id: SERIAL. Yesterday I add three field to the table dalle: time without timezone alle: time without timezone pausa: time without timezone I have made last pg_restore in Febbrary, when I change my PC. Since I have change the schema of 'ore' I can see only the data of the last pg_restore. Then if I try to SELECT on pg_class table I look two occurrence of 'ore': one with relnatts=5 and the other with relnatts=9. Why? I try to add some data to the broken db but psql tell me that I'm trying to add data the already exit in the db. Then all data for Febbraty until today are already contained in the db. It seems that all data added to all any managed by Postgres from March until now can't be accessed. How can I retrieve the missing data? Thanks to all Mauro ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
