ezsystems/ezpublish-kernel — pull request #299 by dpobel (2013-04-15 14:41:34+00:00)
Title: Fix EZP-20652: Database error when creating content with the API in PostreSQL

JIRA: https://jira.ez.no/browse/EZP-20652

# Description

Creating a content with the public API in PostgreSQL does not work because an error occurs while creating the url alias for the newly created content. This error is triggered by the method that retrieve the new id of the url alias because we generate an invalid SQL query for PostgreSQL.

Unfortunately, ezcDatabase does not really abstracted the auto increment ids (see for instance [this *hack*](https://github.com/zetacomponents/Database/blob/master/src/sqlabstraction/query_insert.php#L115)) so the query builder does not really help.

Another solution would have been to run the following SQL query:

``` sql
INSERT INTO ezurlalias_ml_incr VALUES(DEFAULT)
```

but this might not work as expected in MySQL due to [this bug](http://bugs.mysql.com/bug.php?id=42270).

As a result, I wa

# Tests

unit tests (SQLite, MySQL and PostgreSQL with some pain) + script creating content