when i do a vacuum, i see in debug message that my datas are there (1800
tuples etc...)
when i do a select..0 rows !
when i try to insert a data with a duplicate key, i ve got the message that
postgres cannot insert a duplcate key...
so my datas are here..but i can't see them !!
helpp!!
At 14:12 12/02/01 +0100, Jean-Arthur Silve wrote:
>Hi !
>
>I did a pgdump on a database. It was ok
>
>After, all tables have dissapeard ,even those in other databases !
>
>when I check in the data directories, all datas are here, but in pg_class,
>there is no more tables ! (except system tables !)
>
>Is there a way to retrieve my lost tables ?????
>
>jean-arthur
>----------------------------------------------------------------
>Le simple fait de passer par la fenetre ne suffit pas a la transformer en
>porte.
----------------------------------------------------------------
Le simple fait de passer par la fenetre ne suffit pas a la transformer en porte.