telescope
telescope copied to clipboard
SQL error "operator does not exist: boolean = integer" with Postgres
Telescope Version
5.2.1
Laravel Version
11.21.0
PHP Version
8.2.21
Database Driver & Version
psql (PostgreSQL) 14.12 (Homebrew)
Description
Telescope views do not load with Postgres as a database driver. Tested with different Postges versions: 14 and 16.
SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: boolean = integer
LINE 1: ... "type" = 'command' and "should_display_on_index" = 1 order ...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts. (Connection: pgsql, SQL: select * from "telescope_entries" where "type" = command and "should_display_on_index" = 1 order by "sequence" desc limit 50) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42883): SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: boolean = integer
Steps To Reproduce
Fresh Laravel and Laravel Telescope install with Postgres.