#641 Problems Zeos 8 and Postgres 17

[Fausto Alves]

Hi, I'm using Zeos version 8.0 with Lazarus 4.6.
I'm getting the following error with a PostgreSQL 17 connection.
When closing the application, it raises an exception:

Project ComexDoc raised exception class 'External: ACCESS VIOLATION' with message:
Access violation executing address $00007FFEB295B930.
At address 7FFEB295B930.
This exception goes to this method in ZPlainLoader.
~~~
procedure TZNativeLibraryLoader.FreeNativeLibrary;
begin
if (FHandle <> INVALID_HANDLE_VALUE) and (FHandle <> 0) and Loaded then <- In this line
FreeLibrary(Handle);
FHandle := INVALID_HANDLE_VALUE;
FLoaded := False;
FCurrentLocation := '';
end;

I'm working with the client libraries of the same version as the server 17.
The same doesn't happen if I connect to a Postgres version less than or equal to 16.

[marsupilami79]

Hello,

I tried to reproduce the problem but I cannot reproduce it. My system:

• Win 10
• PG 17.6
• Lazarus 4.0-fixes (399d8bb3f263100420309995b621c42ff696ce81)
• FPC 3.2-fixes (4cdc5b1cdff8e81a6d1de622ec586f65c50091c7)
• Zeos from the 8.0-patches branch (8455)

I did the following select:

SELECT * FROM information_schema.collations

I have no problems, when disconnecting.

Best regards,

Jan