Master - detail sequence error

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Luke
Posts: 1
Joined: Sun 12 Jul 2009 14:57

Master - detail sequence error

Post by Luke » Sun 12 Jul 2009 15:10

Hi,
I am using Postgresql server version 8.3.7. Devart dotconnect 4.5.33

If I set up a master detail relationship using Devart dataset wizard - When entering detail records sequences sometimes generate duplicate values, resulting in key violation error. If I only have a single table then sequence generates correctly. Can anyone assist with this? I dont know on which side the error is, Devart or Postgresql server ?

Many thanks
Alfred

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 13 Jul 2009 15:06

How do you enter detail records? Please tell us the exact text of the error and your call stack.
Could you please send us (support*devart*com) a small test project with the DDL and DML script? We will try to reproduce the problem.

Post Reply