From: Pavel PaJaSoft Janousek <janousek@fonet.cz>
To: PgSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Error in indexing?
Date: Wed, 21 Apr 1999 19:37:33 +0200
Message-ID: <000301be8c1d$a43f3aa0$0200a8c0@server.fonet2.cz> (raw)
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
--------------------------------------------------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: janousek@fonet.cz
Subject: Re: Error in indexing?
In-Reply-To: <000301be8c1d$a43f3aa0$0200a8c0@server.fonet2.cz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox