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.
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 ! |