NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
{{Note | PostgreSQL complies to ANSI SQL standards, whereas MySQL does not.}}
== Changes Most common changes in database queries and views from MySQL to PostreSQL ==__NOEDITSECTION__
When upgrading from {{IMSMANG}} 5.08.04 to 6.0, the database views need to be adapted, i.e. changed from MySQL syntax to PostgreSQL syntax. The country focal point is taking care of this. For reference, this section describes the main changes encountered. This can also be used as a tutorial for creating views in PostgreSQL, for {{IMSMANG}} administrators who were used to creating them in MySQL.