[Question] PostgreSQL's pgcrypto uuid generator

[Simperfit]

The postgreSQL Driver does not support pgcrypto's function to generate uuid (gen_random_uuid() returns uuid, it does support uuid-ossp but it is currently unavailable in some provider like Google Cloud SQL (postgres).

Should dbal supports pgcrypto too ?

I'm willing to help contributing to this if it's the case

[Ocramius]

Should dbal supports pgcrypto too ?

Depends on whether it's provided OOTB, and if so, which version implemented it

[Simperfit]

@Ocramius It is, just like uuid-ossp, I think it exist since a long time ago (maybe pgsql 8.2)

[Ocramius]

@Simperfit so I suppose you just want to change

dbal/lib/Doctrine/DBAL/Platforms/PostgreSqlPlatform.php

Line 999 in fbed76e

return 'UUID_GENERATE_V4()';

?

[Simperfit]

@Ocramius I think we should add a new platform and detect if it's either one or either the other in order to not do a BC Break with existing apps that use uuid-ossp.

WDYT ?

[Ocramius]

@Simperfit if we're moving to something that is more widely supported, and the output is the same, then it's fine to just change it as-is

[morozov]

The UUID functionality is deprecated in DBAL by #3212.

[github-actions]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.