On 08/14/2018 05:58 AM, Jarosław Torbicki wrote:
Hello,
I used PostgreSQL 9.3 but I executed upgrade few days ago.
Now, I am using 10.4 PostgreSQL and:
doctrine/annotations v1.2.7
doctrine/cache v1.4.2
doctrine/collections v1.3.0
doctrine/common v2.7.3
doctrine/dbal v2.5.13
doctrine/doctrine-bundle v1.5.2
doctrine/doctrine-cache-bundle v1.0.1
doctrine/inflector v1.0.1
doctrine/instantiator 1.0.5
doctrine/lexer v1.0.1
doctrine/orm v2.5.14
I have a problem with ManyToOne relation.
For example, I have main object with three child and when I execute on
main object
$em = $this->getDoctrine()->getManager();
$em->merge($data);
$em->flush();
I sometimes get ERROR message like:
/Uncaught PHP Exception
Doctrine\DBAL\Exception\UniqueConstraintViolationException: "An
exception occurred while executing 'UPDATE/
I get this ERRROR message not for all main object and not for all
child. For example, first update child object is ok but in second I
get error.
SQL prepared by doctrine:
UPDATE child_table SET id = ?, name = ?, object_name = ?, object_size
= ? WHERE id = ?' with params ["2", "test Name object 2", "test name
object 2", "1234", 3]
In this sql the doctrine tries update object with id=3 using data from
object with id = 2.
This problem didn’t occur before executing upgrade to 10.4 version.
Can you help me and give some tips?
This mailing list is about development of PostgreSQL, not about how to
use it. Please ask in the correct forum (possibly the pgsql-general
mailing list)
cheers
andrew
--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services