"Invisible" relations after migrating Access
От | Anung B. Ariwibowo |
---|---|
Тема | "Invisible" relations after migrating Access |
Дата | |
Msg-id | 20020613061150.220.qmail@web12908.mail.yahoo.com обсуждение исходный текст |
Список | pgadmin-support |
Hi fellow pgadmin users, I have difficulties when issuing a select statement under psql in a database which is migrated from Microsoft Access. I have a MSAccess97 database migrated to PostgreSQL 7.2 using PgAdminII. The migration process was successful, however, when I tried to access the tables using psql in Linux, I got this error message: ERROR: Relation "tablename" does not exist. But when I tried to list all relations in the database using \d, they showed up. It it "invisible" when I tried to "Select"-ing via SQL statement. Even trying to "Alter table tablename owner to dbuser" results in same error message above. Why this happened? Anyone ever seen such problems? Any hints would be appreciated. TIA, -- Ag.B -- barliant@yahoo.com ===== -- Ag.B -- barliant@duabelas.net The Prophet Muhammad (peace be upon him) said: "If Judgment Day comes when you are planting a seedling, if you are able to plant it before the Day arrives, do so." __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com
В списке pgadmin-support по дате отправления: