Here is what I did.
Tools -> PostgreSQL -> DataSet Wizard
Click > to continue
Choose New Dataset "DataSet1"
Use Provider Specific Code is checked
Click > to continue
Check "Show all schemas" (does not matter if unchecked)
Check "Share connection"
Select either type of Data Source (it does not matter, tried both)
Click the button
Enter User ID
Enter Password
Enter Host
Enter Database
Leave Schema blank (also tried "." as I saw somewhere on the forums, but then the test connection will fail.)
Click button
Shows "Successfully connected.
Click the button.
Click the button.
Click the + sign in front of the pgSQLConnection1 (Newly created)
Then the error message appears.
Relation "pg_namespace" does not exist
The Info from the connection test is:
Any help would be appreciated.Client:
Encoding
Server:
Version PostgreSQL 7.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
Encoding
Autocommit
Security:
Password Encryption
SSL