Ispirer Website
Ispirer Capabilities: PostgreSQL Migration
Free Trial
Symptoms
The error may occur during the import into a PostgreSQL database.
Causes
This error message appears if you are not the owner of the table or the owner has not granted you the necessary permissions. Depending on what authentication methods (trust, md5, etc. ) you have set, you may receive the following error when trying to work with a particular table. This is usually caused by creating a table as user 'postgres', and then trying to use it as user 'bob'.
Solutions
There are two solutions to this problem:
ALTER TABLE table_name OWNER TO new_owner_name.
GRANT SELECT ON table_name TO user_name.
If you encounter any difficulties or have additional questions, please contact us at support@ispirer.com.