Schema Tool keeps recreating table user when inside a schema in PostgreSQL #6845
Description
Bug Report
| Q | A |
|---|---|
| Version | 4.2.3 |
Summary
With the following mapping:
#[ORM\Table(schema: 'my')]
class Userwhenever I rerun bin/console make:migration, I'm getting:
$this->addSql('CREATE TABLE my."user" (...)');
$this->addSql('DROP TABLE my."user"');This is apparently due to user being a reserved word in SQL (or PostgreSQL), and the escaping Doctrine applies (as discussed in various issues here).
When I remove the schema, it works as expected:
[WARNING] No database changes were detected.
Workaround:
Rename the table in the database:
#[ORM\Table(name: 'users', schema: 'my')]