Re: Can not deleted all record

Yudha,

"ERROR: Query was cancelled." usually means that the query is taking too long,
and you exceeded the maximum time specified in your postgresql.conf file.

The parameter you want to change is:

statement_timeout = X

where X is in seconds; set X = 0 to turn off the timeout completely (queries
will run as long as they need to).

Andrew

8/29/03 2:35:04 AM, "Yudha Setiawan" <yudha(at)bonbon(dot)net> wrote:

>
>
> From: "Yudha Setiawan" <yudha(at)bonbon(dot)net>
>
> To: <pgsql-admin(at)postgresql(dot)org>
> Subject:[ADMIN] Can not deleted all record
> Date: Fri, 29 Aug 2003 13:35:04 +0700
>
>
>
> 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
>
> ------------------------------------