Plugin do not work with pg4wp

In my project I am using the pg4wp plugin because we needed it running on postgres.
The plugin shows the message:
“Missing Table?— One or more required database tables are missing, please check the Diagnostic Info in the Support tab for details”

It seems the plugin was not able to create the table.

I have tested the plugin elsewhere in standard mysql and copied the table from there.

Even tough the table exists, the error still shows the same

Here is the postgres-compatible sql I used to create the table:

CREATE TABLE wp_as3cf_items (
id BIGSERIAL PRIMARY KEY,
provider VARCHAR(18) NOT NULL,
region VARCHAR(255) NOT NULL,
bucket VARCHAR(255) NOT NULL,
path VARCHAR(1024) NOT NULL,
original_path VARCHAR(1024) NOT NULL,
is_private BOOLEAN NOT NULL DEFAULT FALSE,
source_type VARCHAR(18) NOT NULL,
source_id BIGINT NOT NULL,
source_path VARCHAR(1024) NOT NULL,
original_source_path VARCHAR(1024) NOT NULL,
extra_info TEXT,
originator SMALLINT NOT NULL DEFAULT 0,
is_verified BOOLEAN NOT NULL DEFAULT TRUE,
UNIQUE (source_type, source_id),
UNIQUE (is_verified, originator, id),
UNIQUE (path, id),
UNIQUE (original_path, id),
UNIQUE (source_path, id),
UNIQUE (original_source_path, id),
UNIQUE (provider, bucket, id)
);

Here is the diagnostic info from support tab:

Table Prefix: wp_
WordPress: 6.7.1
Web Server: nginx/1.27.3
PHP: 8.1.31
MySQL: 8.0.35
ext/mysqli: yes
PHP Memory Limit: -1
WP Memory Limit: 40M
Memory Usage: 8 MB
Blocked External HTTP Requests: None
WP Locale: pt_BR
Organize offloads by month/year: Enabled
WP_DEBUG: No
WP_DEBUG_LOG: No
WP_DEBUG_DISPLAY: Yes
SCRIPT_DEBUG: No
WP Max Upload Size: 64 MB
PHP Time Limit: 0
PHP Error Log: /dev/stderr
WP Cron: Enabled
fsockopen: Enabled
allow_url_fopen: Enabled
OpenSSL: OpenSSL 3.0.15 3 Sep 2024
cURL: 7.88.1
Zlib Compression: Enabled
PHP GD: bundled (2.1.0 compatible)
Imagick: Enabled
Basic Auth: Disabled
Proxy: Disabled

Total Media Items: 0
Total Offloaded Media Items: 0
Total Not Offloaded Media Items: 0

Media Library Items: 0
Offloaded Media Library Items: 0
Not Offloaded Media Library Items: 0

Number of Image Sizes: 6

Names and Dimensions of Image Sizes:
thumbnail (150×150)
medium (300×300)
large (1024×1024)
1536×1536 (1536×1536)
2048×2048 (2048×2048)

WP_CONTENT_DIR: /var/www/html/wp-content
WP_CONTENT_URL: https://portaljusbr-dev.stg.pdpj.jus.br/wp-content
UPLOADS: Not defined
WP_PLUGIN_DIR: /var/www/html/wp-content/plugins
WP_PLUGIN_URL: https://portaljusbr-dev.stg.pdpj.jus.br/wp-content/plugins

AS3CF_PROVIDER: Not defined
AS3CF_BUCKET: Not defined
AS3CF_REGION: Not defined
AS3CF_SETTINGS: Not defined

Local URL:
https://portaljusbr-dev.stg.pdpj.jus.br/wp-content/uploads/2025/01/example.jpg
Offload URL:
https://portal-media-jus.s3.sa-east-1.amazonaws.com/wp-content/uploads/2025/01/29165816/example.jpg

OME Metadata Version: 12

Custom tables:
wp_as3cf_items: Missing

Storage Provider: Amazon S3
Use Server Roles: On
Key File Path: N/A
Access Keys Set: No
Access Key ID Define: Not defined
Secret Access Key Define: Not defined

Bucket: portal-media-jus
Region: sa-east-1
Block All Public Access: Disabled
Object Ownership Enforced: No

Offload Media: On
Remove Local Media: On
Enable Add Prefix to Bucket Path: On
Custom Prefix for Bucket Path: wp-content/uploads/
Add Year & Month to Bucket Path: On
Add Object Version to Bucket Path: On

Delivery Provider: Amazon S3
Deliver Offloaded Media: On

Force HTTPS: Off

Active Theme Name: CNJ Portal Jus
Active Theme Version: 1.0
Active Theme Folder: portal-jus

Active Plugins:
Advanced Custom Fields (v6.3.6) by WP Engine
Sucuri Security – Auditing, Malware Scanner and Hardening (v1.9.4) by Sucuri Inc.
WP Offload Media Lite (v3.2.11) by Delicious Brains

Drop-ins:
db.php – PostgreSQL for WordPress (PG4WP)