[SequelizeDatabaseError]: relation "sequelizemeta" does not exist about sequelize-typescript-migration HOT 6 OPEN

If the table name can be case insensitive, you can try to enable quoteIdentifiers: false, Sequelize will not create tables with quotes.

It's worked for me. For example:

const sequelize: Sequelize = new Sequelize(
  process.env.POSTGRES_DB || '',
  process.env.POSTGRES_USER_NAME || '',
  process.env.POSTGRES_PASSWORD || '',
  {
    dialect: 'postgres',
    port: 5432,
    database: process.env.POSTGRES_DB,
    host: process.env.HOST || '',
    pool: {
      max: 20,
      min: 0,
      acquire: 30000,
      idle: 10000,
    },
    quoteIdentifiers: false,
    logging: true,
    models: [__dirname + '/src/models'],
  },
);

from sequelize-typescript-migration.

@Pietrox #3

from sequelize-typescript-migration.

I created 2 views in database:

CREATE VIEW SequelizeMeta AS SELECT * FROM "SequelizeMeta";
CREATE VIEW SequelizeMetaMigrations AS SELECT * FROM "SequelizeMetaMigrations";

it`s clumsy, but works

from sequelize-typescript-migration.

If the table name can be case insensitive, you can try to enable quoteIdentifiers: false, Sequelize will not create tables with quotes.

It's worked for me. For example:

const sequelize: Sequelize = new Sequelize(
  process.env.POSTGRES_DB || '',
  process.env.POSTGRES_USER_NAME || '',
  process.env.POSTGRES_PASSWORD || '',
  {
    dialect: 'postgres',
    port: 5432,
    database: process.env.POSTGRES_DB,
    host: process.env.HOST || '',
    pool: {
      max: 20,
      min: 0,
      acquire: 30000,
      idle: 10000,
    },
    quoteIdentifiers: false,
    logging: true,
    models: [__dirname + '/src/models'],
  },
);

it works but make problem in camel case column in models!

from sequelize-typescript-migration.

I fork project and fix the problem . use this package instead.
npm uninstall sequelize-typescript-migration
npm i sequelize-typescript-migration-fix
and change your import to
import { SequelizeTypescriptMigration } from "sequelize-typescript-migration-fix";

from sequelize-typescript-migration.

For me it was resolved by adding searchPath to my config:

  "development": {
    "url": "postgres://postgres:wouldntyouliketoknow@db:5432/postgres",
    "dialect": "postgres",
    "dialectOptions": {
      "searchPath": "public",
      "prependSearchPath": true
    }
  },

from sequelize-typescript-migration.