Fórum

6.0.2 not working with PostgreSQL

Thomas Kellerer, modificado 13 Anos atrás.

6.0.2 not working with PostgreSQL

Expert Postagens: 490 Data de Entrada: 09/06/08 Postagens Recentes
Hi,

as we are planning to use some of the new 6.0 features we tested 6.0.2 but unfortunately it will not work properly with PostgreSQL due to an incorrect SQL syntax.

When assigning permissions to a role, apparently a SQL is constructed that compares apples to oranges (int to varchar) and it is rightfully be refused by Postgres.

I logged this error as issue 10193
http://issues.liferay.com/browse/LPS-10193

Is there any chance that this will be fixed for 6.0 final release?

Otherwise we would need to stick with 5.2.3

Regards
Thomas
thumbnail
JR Houn, modificado 13 Anos atrás.

RE: 6.0.2 not working with PostgreSQL

Expert Postagens: 488 Data de Entrada: 19/11/07 Postagens Recentes
Hi Thomas,
I've tested out your issue and bumped up its priority in getting fixed by 6.0 GA.

regards,
jr
Thomas Kellerer, modificado 13 Anos atrás.

RE: 6.0.2 not working with PostgreSQL

Expert Postagens: 490 Data de Entrada: 09/06/08 Postagens Recentes
JR Houn:
Hi Thomas,
I've tested out your issue and bumped up its priority in getting fixed by 6.0 GA.
Thanks a lot! That is very good news
I just hope that was the only "apples to oranges" SQL in there ;)
thumbnail
JR Houn, modificado 13 Anos atrás.

RE: 6.0.2 not working with PostgreSQL

Expert Postagens: 488 Data de Entrada: 19/11/07 Postagens Recentes
Hey Thomas -
Your ticket (http://issues.liferay.com/browse/LPS-10193) was fixed recently. Grab the fix and let us know if there are any other issues.

regards,
-jr