Search code examples
node.jspostgresqlloopbackjsloopback

Loopback Model discovery from PostgreSQL error


I am currently building a loopback project and I need to discover existing data in a PostgreSQL database to make my models, I have successfully created the models by following the tutorial found in the docs: https://loopback.io/doc/en/lb3/Discovering-models-from-relational-databases.html#discover-and-save-model-definitions , but when I run GET method for any model I get an error that says

relation "public.acl" does not exist

can anyone help me fix this issue, Thanks in Advance.


Solution

  • Thanks @Marvin, i solved the problem by running this auto update script in ./server/boot/migrateTables.js :

    'use strict';
    
    module.exports = migrateTables;
    
    function migrateTables(server) {
      var storage = server.datasources.db;
    
      storage.autoupdate();
    }