I tried to connect from another computer: the same tables cannot be opened.
What would be in PG that ODBC uses and psql does not?
Mihai
-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mihai Gheorghiu <tanethq@earthlink.net>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Date: Wednesday, August 01, 2001 11:14 AM
Subject: Re: [GENERAL] Corrupted tables?
>"Mihai Gheorghiu" <tanethq@earthlink.net> writes:
>> I double-checked:
>> - It is the tables that were included in the MSAccess querry that can no
>> longer be accessed by MSAccess.
>> - The tables in question can be viewed with psql and PGAccess.
>
>Well, if you can read the tables with psql then they're not "broken".
>It sounds like the problem must be on the MSAccess side --- does
>MSAccess have any persistent state that you can reset? (preferences
>file maybe?)
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster