Adding the LIBNAME option PRESERVE_TAB_NAMES=YES when using SAS/ACCESS Interface to PostgreSQL might result in the following error when you try to access a table in PostgreSQL:

POSTGRES: ROLLBACK performed on connection 1.
ACCESS ENGINE: ERROR: CLI describe error: ERROR: zero-length delimited
identifier at or near """";
No query has been executed with that handle

The error can occur when your tables in PostgreSQL are case sensitive and you are also specifying a schema in the LIBNAME statement. By default, the Postgres engine is wrapping the schema in quotation marks and passing the query to the database. When PRESERVE_TAB_NAMES=YES is also specified, it adds an extra set of quotation marks, resulting in the error above.

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

Operating System and Release Information

A fix for this issue for SAS/ACCESS Interface to PostgreSQL 9.4_M3 is available at:

A fix for this issue for SAS/ACCESS Interface to PostgreSQL 9.4_M2 is available at: