[Bug]: Incompatible with Redshift (Postgres)

[fissible]

What happened?

We have set up a Redshift instance and after connecting our application with it using this tool, we get the following error:

Undefined table: 7 ERROR: relation "pg_catalog.pg_collation" does not exist (Connection: redshift, SQL: select a.attname as name, t.typname as type_name, format_type(a.atttypid, a.atttypmod) as type, (select tc.collcollate from pg_catalog.pg_collation tc where tc.oid = a.attcollation) as collation, not a.attnotnull as nullable, (select pg_get_expr(adbin, adrelid) from pg_attrdef where c.oid = pg_attrdef.adrelid and pg_attrdef.adnum = a.attnum) as default, '' as generated, col_description(c.oid, a.attnum) as comment from pg_attribute a, pg_class c, pg_type t, pg_namespace n where c.relname = 'SNIP' and n.nspname = current_schema() and a.attnum > 0 and a.attrelid = c.oid and a.atttypid = t.oid and n.oid = c.relnamespace order by a.attnum)

I initially set up a Discussion topic on this issue.

How to reproduce the bug

Set up a Redshift database in AWS that implements the Postgres API and connect to it via Laravel. It appears that Redshift does not expose or implement the pg_catalog.pg_collation shema.table that this library seems to depend on.

Package Version

0.13.8

PHP Version

8.2

Laravel Version

12.43.1

Which operating systems does with happen with?

No response

Notes

No response