Multiple schema in same postgresql will result migration fails on citext about skygear-server HOT 1 CLOSED

It appears that extension is created specific to schema. Therefore we might need to specify the schema when creating the extension.

Many examples on the web do this, where public is the name of the schema.

CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public;

Quoting documentation on CREATE EXTENSION (emphasis mine):

The name of the schema in which to install the extension's objects, given that the extension allows its contents to be relocated. The named schema must already exist. If not specified, and the extension's control file does not specify a schema either, the current default object creation schema is used.

from skygear-server.