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

can you show the migration where you created the table.

zjbarg
– zjbarg

2018-09-17 05:39:40 +00:00
Commented Sep 17, 2018 at 5:39 — zjbarg
– zjbarg, Commented Sep 17, 2018 at 5:39
stackoverflow.com/questions/26522292/… this may help you.

Chonchol Mahmud
– Chonchol Mahmud

2018-09-17 06:05:21 +00:00
Commented Sep 17, 2018 at 6:05 — Chonchol Mahmud
– Chonchol Mahmud, Commented Sep 17, 2018 at 6:05

omitobi · Accepted Answer · 2018-09-17 07:15:14Z

1

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.

edited Sep 17, 2018 at 7:15

answered Sep 17, 2018 at 6:56

omitobi

7,3543 gold badges39 silver badges55 bronze badges

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

Collectives™ on Stack Overflow

Change column in table have an enum type in postgres

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related