Change column in table have an enum type in postgres

Question

This is my code:

public function up()
{
    Schema::table('organization_user', function (Blueprint $table) {
        $table->renameColumn('company_id', 'organization_id');
    });
}

I want to rename column in table. And in this table have an column is enum type. But errors: Unknown database type company_roles requested, Doctrine\DBAL\Platforms\PostgreSQL100Platform may
not support it. I use laravel 5.6

https://stackoverflow.com/questions/26522292/how-can-i-rename-column-in-laravel-using-migration this may help you. — Chonchol Mahmud, Sep 17 '18 at 06:05

Oluwatobi Samuel Omisakin · Answer 1 · 2018-09-17T07:15:14.277

This issue may be related to what is mentioned in Laravel Docs "You can't rename columns in the table that has 'enum' type". See:

I am afraid this is like 5 years old issue with Doctrine/DBal that Laravel uses see:[Bug] Schema builder - renameColumn fails on table with enum columns But one of the workarounds is also on the same issue report DB Query. For reference sake I'll put it here:

DB::statement("ALTER TABLE table_name MODIFY COLUMN column_name ENUM('Here','is','choices')");

In this case, you need to provide the right statement in the down() function of your migration class file to restore the state of the table.

Change column in table have an enum type in postgres

1 Answers1