Using Postgresql Schemas with Sequelize

Question

I am trying to drop all tables in a schema (Postgres 9.3). When the models were being created, I have specified which schema they belong to.

model.schema( "schema_name")

And I was able to generate all tables in this specific schema. No problem here. However, when I want to drop the tables in the same schema, I am having to explicitly set the search path for it to be successful.

        db.sequelize.query("set search_path=consumer")
        .then( function( arg ){
            db.sequelize.drop({cascade:true})
                .then( function( arg ){
                    fulfill( arg );
                },function( err ){
                    reject( err );
                });
        });

When Sequelize claims support for PostgreSQL schema, I would expect that this detail must have been taken care of (because most of the other features work charmingly well!). So my question is : Do I have to set search path or am I missing some option that I am not making use of?

Raymond Array Wang · Accepted Answer · 2016-04-08 01:30:26Z

2

sequelize creates a clone of the object, sets the schema on it and returns the clone. Therefore the original object is unchanged.

Try model.schema( "schema_name") instead.

answered Apr 8, 2016 at 1:30

Raymond Array Wang

1961 silver badge12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using Postgresql Schemas with Sequelize

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related