Flowise icon indicating copy to clipboard operation
Flowise copied to clipboard

BugFix/Patch: PostGreSQL Record Manager

Open Nek-11 opened this issue 8 months ago • 0 comments

In #4381 I proposed a fix for time handling and schema creation in PostgresRecordManager.

However, I made a mistake there. The CREATE EXTENSION IF NOT EXISTS pgcrypto; line causes failures on Azure Database for PostgreSQL Flexible Server where such commands are blocked, even if the extension is already installed. Therefore, this PR removes that line.

It also updates the getTime() query to use AS extract instead of AS now, in order to preserve 100% backward compatibility with existing code that expects res[0].extract.

Nek-11 avatar May 15 '25 13:05 Nek-11