Support flags: ['fulltext'] for postgres

[tacman]

Feature Request

Q	A
New Feature	yes
BC Break	no

Summary

It appears that

#[ORM\Index(name: "article_fulltext", columns: ["headline", "summary"], flags: ["fulltext"])]#

Only works with MySQL. It would be nice if this generated the index for Postgres as well. And even SQLite.

Basically building in at least the tool that creates the index in this bundle: https://github.com/jaimz22/DoctrineFullTextPostrgres

[greg0ire]

Transferring to DBAL since the code that causes this to work with MySQL resides:

dbal/src/Platforms/AbstractMySQLPlatform.php

Lines 1054 to 1055 in 7c4aa97

	} elseif ($index->hasFlag('fulltext')) {
	$type .= 'FULLTEXT ';

[antoniovj1]

@greg0ire @tacman @derrabus Is some help needed with this?

[tacman]

I don't think I'll be able to do it, but wanted to bring up the issue hoping someone else with more experience would.

[antoniovj1]

I don't know the ins and outs of Doctrine but I think I could take a look and try to implement it.

[antoniovj1]

Probably I'll need some investigation because the necessity of handling two columns. I'm not sure if doctrine is doing this for other cases.