| 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: | Whole Thread | Raw Message | 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
------------------------------------
| 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 |