Neslisah Demirci wrote:
> First I started conversation between two person ;
>
>
> sql: 'INSERT INTO "XXXXX"
> ("id","customer","createdAt","updatedAt","CompanyId") VALUES
> (DEFAULT,\'905322653555\',\'2017-01-17 19:13:37.751 +00:00\',\'2017-01-17
> 19:13:37.751 +00:00\',\'1\') RETURNING *;' },
>
>
> name: 'error', length: 274, severity: 'ERROR', code: '40001', detail: 'Reason
> code: Canceled on identification as a pivot, during write.', hint: 'The
> transaction might succeed if retried.', position: undefined,
> internalPosition: undefined, internalQuery: undefined, where: undefined,
> schema: undefined, table: undefined, column: undefined, dataType: undefined,
> constraint: undefined, file: 'predicate.c', line: '4605', routine:
> 'OnConflict_CheckForSerializationFailure',
>
>
>
> Secondly ; i inserted messages as below;
>
>
> Begin;
>
> 'INSERT INTO "YYYYY"
> ("id","body","from","to","state","data","xId","createdAt","updatedAt","CompanyId","MessageTypeId","ConvId")
> VALUES
> (DEFAULT,\'messagetext\',\'905309788255\',\'905309788200\',\'customer\',NULL,\'463DA712296218E0D4\',\'2017-01-17
> 06:43:19.228 +00:00\',\'2017-01-17 06:43:19.228 +00:00\',\'1\',1,23286)
> RETURNING *;'
>
> commit;
Are there triggers or foreign keys in these tables?
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
