The following error occurs when you try to open a large PostgreSQL table with SAS/ACCESS® Interface to ODBC.

By default, the PostgreSQL ODBC driver loads the entire table into memory, which can lead to out-of-memory conditions or other error conditions in the driver. The error returned to SAS indicates that the table does not exist and the error message is produced.

You can change this behavior in the PostgreSQL ODBC-driver setup dialog window by enabling the Use Declare/Fetch option under Datasource Options. This option enables the driver to keep only a small subset of the table in memory, and then the table can be accessed from SAS successfully.