db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John English <john.fore...@gmail.com>
Subject Re: adding a record to a table
Date Sat, 15 Feb 2014 12:57:44 GMT
On 15/02/2014 04:57, Bob M wrote:
> Hi
>
> I have a table in which the key is the first two fields viz date and time
> the last two records in the table are
> 2014-02-14      0   .......................
> 2014-02-14      6   ......................
>
> When I try to add a new record
>
> 2014-02-14     12   ........................
>
> I get Error code-1, SQL state 23505
> Insert command failed: The statement was aborted because it would have
> caused a duplicate key value in a unique or primary key constraint or unique
> index indentified by 'SQL14021012215370' defined on 'table name'
>
> What does this error mean ?

Naming your constraints is a good idea, since then you can see exactly what is 
being violated. It could be that the constraint that is causing the problem is 
not the primary key in this table but something completely different. Without 
seeing the table spec and the failing query, it's hard to tell from here.
-- 
John English

Mime
View raw message