Database Notifications Not work When i Use Postgres

[mstfkhazaal]

Package

filament/filament

Package Version

v3.2.117

Laravel Version

v11.27.2

Livewire Version

No response

PHP Version

PHP 8.2

Problem description

Database Notifications Not work When i Use Postgres

I get this error:

SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: text ->> unknown LINE 1: 
...ifications"."notifiable_id" is not null and "data"->>'format... ^ HINT: No operator matches the given name and argument
types. You might need to add explicit type casts. (Connection: pgsql, SQL: select * from "notifications" where
"notifications"."notifiable_type" = App\Models\User\User and "notifications"."notifiable_id" = 1 and
"notifications"."notifiable_id" is not null and "data"->>'format' = filament order by "created_at" desc limit 51 offset 0)

Expected behavior

Work Normal

Steps to reproduce

1. Clone Repository https://github.com/mstfkhazaal/postgres_notification/
2. Install Postgres or use via Laravel Sail (sail up -d)
3. Run this codes

cp .env.example .env
php artisan key:generate
php artisan migrate:fresh --seed

4. Got To http://localhost/admin/login
5. Login: Email: [email protected] Password: password

Reproduction repository (issue will be closed if this is not valid)

https://github.com/mstfkhazaal/postgres_notification/

Relevant log output

SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: text ->> unknown LINE 1: 
...ifications"."notifiable_id" is not null and "data"->>'format... ^ HINT: No operator matches the given name and argument
types. You might need to add explicit type casts. (Connection: pgsql, SQL: select * from "notifications" where
"notifications"."notifiable_type" = App\Models\User\User and "notifications"."notifiable_id" = 1 and
"notifications"."notifiable_id" is not null and "data"->>'format' = filament order by "created_at" desc limit 51 offset 0)

Donate 💰 to fund this issue

• You can donate funding to this issue. We receive the money once the issue is completed & confirmed by you.
• 100% of the funding will be distributed between the Filament core team to run all aspects of the project.
• Thank you in advance for helping us make maintenance sustainable!