I am trying to connect my API to an instance of Redshift using the 'pg' library but I get the following error:
Possibly unhandled error: SET TIME ZONE is not supported
at Connection.parseE (/Users/henrylee/WebstormProjects/project-api/node_modules/pg/lib/connection.js:534:11)
I know Redshift doesn't support the setting of timezone, but I don't really care about that. I can't seem to find any help about how to get past this issue, so any inout would be greatly appreciated. Thanks!