Can not deleted all record

From: "Yudha Setiawan" <yudha(at)bonbon(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Can not deleted all record
Date: 2003-08-29 06:35:04
Message-ID: 1ccf01c36df8$2709da60$ea00a8c0@yudha
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear expert;

I've tried to update my record on stock's table.
but i failed "ERROR: Query was cancelled."
was show up. But when i update on partial `till
all my record is changed, its work.
Anyway that's table have no rule,trigger and relation
with the other table. I've been thinking we must vacuum
this table.
But when i tried Vacuum with "Vacuum full verbose analyze
d_master.t_stock;" the "ERROR: Query was cancelled." is
show up again.
Which part on my pg_hba.conf that indicates this error ????
or any idea about this ????

Please gimme your hand. I couldn't reset my table :(

GOD Bless You All and Bravo Postgres
------------------------------------

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Biagioni 2003-08-29 12:21:37 Re: Can not deleted all record
Previous Message Bruno Wolff III 2003-08-29 02:44:31 Re: Hi, I have a question regarding the postgresql scripting