| From: | mail TechEvolution <mail(at)techevolution(dot)be> |
|---|---|
| To: | Scott Ribe <scott_ribe(at)killerbytes(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: problem after restoring a backup database on a different |
| Date: | 2005-07-15 17:41:30 |
| Message-ID: | 42D7F54A.1070401@techevolution.be |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Scott
i don't know, i do just the exact thing, with exact users and one the
other pc (where the db is not original created, + tried on 3 different
pc) it is not working.
i can restore the database, the tables and data is there, but i cannot
use the tables
i can connect to the database itself, but when i try to run an easy sql
statement as select * from table, i recieve:
relation "table" does not exist
if it had to do with the user, i wouldn't be able to restore the
database, right?
do you think it has to do with the schema? (wich i do not know what you
mean by this, i ame a novice to PostGreSQL) if so, can you help me what
i can do to check this?
greetZ
wes
Scott Ribe schreef:
>>do you have any idea what i do wrong or what can be going wrong?
>>
>>
>
>Something to do with difference re database user or schema???
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2005-07-15 17:54:45 | Re: CVS - psql segfault |
| Previous Message | Andrus | 2005-07-15 17:33:17 | Re: How to create unique constraint on NULL columns |