Thread: Error in indexing?

Error in indexing?

From
"Pavel PaJaSoft Janousek"
Date:
    Hi all,

    by the work on one project, I see this situation:
I have table, it has primary key.. psql automaticly create unique key for
this column. - OK
Now, I insert one row into this table... - OK
Now, I delete this row from the table... - OK
And now, I can insert row to this table with the same values as
previous... - BAD:-(

    I got message from sqlca, that I cannot insert a duplicate key into a
unique index...

    I thought, that inserting and deleting rows from database is transparent
and automaticly created indexes are corectly updates by values in the table.
Is very badly, that I must think that table XX has a unique index and after
deleting some rows I must update a index...

    And now, when I have this situation, I try use vacuum, but I can't
insert the same row again...

    I think one posible way... - delete neccessery rows, drop index and
create new index... - but this is ...'-)

    Can somebody help me with this, I use ECPG distributed with PostgreSQl
6.4.2 - is this bad situation error for this release and will be fixed in
version 6.5? I permanently monitoring situation by version 6.5, I think,
that is currectly beta2, but I know, that it has still some problems and
errors, so I can't use it for now...

    Thanks...

-------------------------------------------------------------------------
Pavel Janousek (PaJaSoft)                         FoNet, spol. s r. o.
Vyvoj software, sprava siti, Unix, Web, Y2K     Anenska 11, 602 00  Brno
E-mail: mailto:Janousek@FoNet.Cz                Tel.: +420  5  4324 4749
SMS:    mailto:P.Janousek@SMS.Paegas.Cz         Fax.: +420  5  4324 4751
WWW:    http://WWW.FoNet.Cz/                  E-mail: mailto:Info@FoNet.Cz
--------------------------------------------------------------------------