How to replace column value?

[hketen]

Hello,

An error occurs if the old value (used value) in the enum is removed.

For example;

Old enum newValues: ['car', 'bike']

 await replaceEnum({
   queryInterface,
   tableName: Product.tableName,
   columnName: 'product_type',
   newValues: ['car1', 'car2', 'car3', 'car4', 'bike1', 'bike2', 'bike3'],
});

Error: VError: Original error: invalid input value for enum enum_product_product_type_new: "car"

[cyrilchapon]

@hketen, 2 choices :

• Not using replaceEnum at all; and rather using internal functions, respectively in order createEnum / <make your update on data here> / dropEnum / renameEnum
• Making some local temporary updates in a multi-step logic, see example below

Basically :

• (temporarily change column to Nullable if needed)
• Select items to update (to keep them for later update)
• Temporarily update the column value on them to null
• Update the enum (remove the value)
• Fix their value with any rule you want
• (reset column to non-Nullable if needed)

Don't forget to do all of this inside a single transaction, ideally with a lock on the initial select

[eleezs]

@hketen please how did you append a schema to the table name?

When ever i try it, it doesn't seem to work. I get this error:

ERROR: relation "schema.me" does not exist 

But the table name exists