Another solution for supabase specifically: Add topology to the extra search path
Go to Project Settings -> Configuration -> Data API Change extra search path's value from public, extensions to public, extensions, topology
Project Settings -> Configuration -> Data API
extra search path
public, extensions
public, extensions, topology