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" <[EMAIL PROTECTED]> wrote:
>
>
> From: "Yudha Setiawan" <[EMAIL PROTECTED]>
>
> To: <[EMAIL PROTECTED]>
> 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
>
> ------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
