Cannot call pg expression JSON_ARRAY. Does not exist
I'm using Laravel and created a migration where the json would have a default empty json array.
When I run the migration locally, it works all fine, my pg 17.2 database works all fine. However, in supabase, when I run my migration I get an sql error that json array function does not exist.
$table->json('movies')->default(new Expression('(JSON_ARRAY())'));When I run the migration locally, it works all fine, my pg 17.2 database works all fine. However, in supabase, when I run my migration I get an sql error that json array function does not exist.