precisions on : Porstgress forgot all ! Help !

From: Jean-Arthur Silve <jeanarthur(at)eurovox(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: precisions on : Porstgress forgot all ! Help !
Date: 2001-02-12 13:21:04
Message-ID: 4.3.0.20010212141923.00b47ad0@mail.eurovox.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-02-12 15:44:38 Re: Error with LEX code generation on hpux10.20
Previous Message Jean-Arthur Silve 2001-02-12 13:12:31 Porstgress forgot all ! Help !