Re: Error: "Out of memory while reading tuples." in pushing table from SAS to PostgreSQL on Mac - Mailing list pgsql-general

>
> Ah!  That would explain it.
>
> Welp, this search was more helpful: "Out of memory while reading tuples"
>
> http://stackoverflow.com/questions/22532149/vba-and-postgresql-connection
>
> It says: include UseDeclareFetch=1 in connect string, which sounds like its part of odbc.  How does SAS connect to
PG?
>
> -Andy
>

Here is another reference that describes the same problem:


https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4498d4f2-9646-4921-b56d-79e22c14a215/import-data-from-postgresql-into-sql-server-2005

The answer (very bottom) is to set the "use declare/fetch" option in psqlODBC driver options.


-Andy