DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=QnpdKxpiezwTK00r3jH+owImXZbyCGeLSaduQSICWa9jqh2/xfCJ5688PoA23PtLIYZf3Ygf4hcFbP3fw45PR6qi7cMleTf8EfzBe9tDGky3uv1fYxbRoV1TZN20wGxXpZAC8eN/RWgVgS94Wi9XtgGIOW2ZzwVGfDl2zwwZPXo=
	;
Message-ID: <20051206083838.90175.qmail@web31508.mail.mud.yahoo.com>
Date: Tue, 6 Dec 2005 00:38:38 -0800 (PST)
From: Jenny <jenny_tania@yahoo.com>
Subject: need help
To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org,
	pgsql-performance@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

I'm running PostgreSQL 8.0.3 on i686-pc-linux-gnu (Fedora Core 2). I've been
dealing with Psql for over than 2 years now, but I've never had this case
before.

I have a table that has about 20 rows in it.

       Table "public.s_apotik"
    Column         |          Type                |     Modifiers
-------------------+------------------------------+------------------
obat_id            | character varying(10)        | not null
stock              | numeric                      | not null
s_min              | numeric                      | not null
s_jual             | numeric                      | 
s_r_jual           | numeric                      | 
s_order            | numeric                      | 
s_r_order          | numeric                      | 
s_bs               | numeric                      | 
last_receive       | timestamp without time zone  |
Indexes:
   "s_apotik_pkey" PRIMARY KEY, btree(obat_id)
   
When I try to UPDATE one of the row, nothing happens for a very long time.
First, I run it on PgAdminIII, I can see the miliseconds are growing as I
waited. Then I stop the query, because the time needed for it is unbelievably
wrong.

Then I try to run the query from the psql shell. For example, the table has
obat_id : A, B, C, D.
db=# UPDATE s_apotik SET stock = 100 WHERE obat_id='A';
(.... nothing happens.. I press the Ctrl-C to stop it. This is what comes out
:)
Cancel request sent
ERROR: canceling query due to user request

(If I try another obat_id)
db=# UPDATE s_apotik SET stock = 100 WHERE obat_id='B';
(Less than a second, this is what comes out :)
UPDATE 1

I can't do anything to that row. I can't DELETE it. Can't DROP the table. 
I want this data out of my database.
What should I do? It's like there's a falsely pointed index here.
Any help would be very much appreciated.


Regards,
Jenny Tania


__________________________________________ 
Yahoo! DSL – Something to write home about. 
Just $16.99/mo. or less. 
dsl.yahoo.com