From: | Andrew Biagioni <andrew(dot)biagioni(at)e-greek(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org, "Yudha Setiawan" <yudha(at)bonbon(dot)net> |
Subject: | Re: Can not deleted all record |
Date: | 2003-08-29 12:21:37 |
Message-ID: | C8BB7H1YXGDLFKJRQC951LG3WDAOM.3f4f4551@Laptop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
>
> ------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Raphael Bauduin | 2003-08-29 13:12:40 | wrong password accepted |
Previous Message | Yudha Setiawan | 2003-08-29 06:35:04 | Can not deleted all record |