In some cases, when reading large amounts of data from PostgreSQL into SAS^® software, you might encounter an error similar to the following:

If you are using SAS/ACCESS^® Interface to PostgreSQL, adding the PostgreSQL driver option UseDelcareFetch can help eliminate this error. When you use this option in a LIBNAME or Explicit Pass-Through statement, you must also use the CONOPTS= option, as shown below:

If you are  using the open-source PostgreSQL driver with SAS/ACCESS^® Interface to ODBC, you must add the option to your ODBC data source.

Click the Hot Fix tab in this note to access the hot fix for this issue.

The hot fix in this SAS Note is for the Threaded Kernel Table Services (TKTS) PostgreSQL Driver commonly used by SAS^® Federation Server. This hot fix adds a TK option called USE_DECLARE_FETCH and sets it to YES by default. If you do not want this option enabled after applying the hot fix, you can add the option to the connection string to disable it by specifying NO, as shown below:

Operating System and Release Information

A fix for this issue for SAS Threaded Kernel Extension for PostgreSQL 9.4_M6 is available at: