Re: [SQL] Problem with Auto Increment

2002-11-04 Thread Stephan Szabo
On Mon, 4 Nov 2002, Ben Kassel wrote: > When I try to create a new row in this table and do not explicitly > define a unique value for datadefindex I get the following error > message: > More information : If I DROP the database, recreate it, and enter > values into the table manually, the auto

[SQL] Problem with Auto Increment

2002-11-04 Thread Ben Kassel
When I try to create a new row in this table and do not explicitly define a unique value for datadefindex I get the following error message: ERROR: Cannot insert a duplicate key into unique index datadef_pkey Here is the INSERT statement that generated the error: tmdb=# insert into datadef (