Error with 2009.2 with PostgreSQL (2)

[forgetms]

Hi!

When I was trying to link autonomous page to main menu, I got the following error:

Mosmenu:store

ERROR:  column "browserNav" of relation "menu" does not exist at character 98
STATEMENT:  INSERT INTO menu ( "menutype","name","link","type","published","componentid","parent","ordering","browserNav","access","params","language" ) VALUES ( 'mainmenu','Contact Us','index.php?option=com_content&task=view&id=10','content_typed','1','10','0','9999','0','29','menu_image=-1
   menu_image_only=0','chinese_traditional' )

Regards,
CN

[rentasite]

someone merge this topic with this http://bit.ly/axBbfH plz 

[datahell]

Elxis 2009.2 is not 100% compatible to postgreSQL. I suggest you to use mysql for now.
Elxis will become again fully compatible with postgreSQL on version 2011.0.

[forgetms]

Elxis 2009.2 is not 100% compatible to postgreSQL. I suggest you to use mysql for now.
Elxis will become again fully compatible with postgreSQL on version 2011.0.

Thank you for the explanation!

Since I stick only to PostgreSQL and I can't wait for version 2011.0, I replaced all "GROUP BY" with "ORDER BY". Now the annoying errors are gone although I do not know what side effects will be resulted.