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
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
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
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 RecentesJR Houn:
Hi Thomas,Thanks a lot! That is very good news
I've tested out your issue and bumped up its priority in getting fixed by 6.0 GA.
I just hope that was the only "apples to oranges" SQL in there ;)
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
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