From: | Tsirkin Evgeny <tsurkin(at)mail(dot)jct(dot)ac(dot)il> |
---|---|
To: | Andrei Bintintan <klodoma(at)ar-sd(dot)net> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: duplicates |
Date: | 2004-09-06 07:57:00 |
Message-ID: | Pine.LNX.4.58.0409061050190.20694@p-roman.jct.ac.il |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Mon, 6 Sep 2004, Andrei Bintintan wrote:
> If still got problems, please post some queries, be more specific.
>
> Best regards,
> Andy.
>
Ok i will try:
CREATE TABLE schedule (
studentid decimal(9),
groupid decimal(10),
maslulsignid decimal(7),
tfusot varchar(29)
);
that is the table for writing down the courses/groups
a students takes.note there is NO unique constrain here
(maybe it should be but that the way it is and probably
can't can't be changed).while changing groups for a student
the applic. deletes all the groups the student had :
delete from schedule where studentid=11111;
and then inserts the new groups (regular inserts).
Now sometimes we got duplicates of the same groupid and
studentid in the table(everything is same).i thought that \
maybe the delete do not delete but the insert succeed?
Note :I know that there could be created the a unique key and
a constrain but befor we have to understand why the duplicates
were created.
--
Evgeny.
From | Date | Subject | |
---|---|---|---|
Next Message | Andrei Bintintan | 2004-09-06 08:31:12 | Re: duplicates |
Previous Message | Andrei Bintintan | 2004-09-06 07:48:17 | Re: duplicates |