Hi Seemant,

> I do indeed get an error:
>
> SQL error: PRIMARY KEY must be unique

Unfortunately, that's not the error I was expecting :)

This error indicates that a record with id=2 already exists perhaps
from your original tests and development work.

Assuming that this table only has test data that you are fine deleting,
please try these 3 statements:

delete from "sermons_scripture";

insert into  "sermons_scripture" (id, book, chapter, from_verse,
to_verse, passage) values (1, "1", 1, 1, 2, "passage");

insert into  "sermons_scripture" (id, book, chapter, from_verse,
to_verse, passage) values (2, "1", 1, 1, 2, "passage");

You should get an Integrity Error that says that the 4 fields in
question are not unique.

-Rajesh


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---

Reply via email to