Re: Can not deleted all record
От | Andrew Biagioni |
---|---|
Тема | Re: Can not deleted all record |
Дата | |
Msg-id | C8BB7H1YXGDLFKJRQC951LG3WDAOM.3f4f4551@Laptop обсуждение исходный текст |
Ответ на | Can not deleted all record ("Yudha Setiawan" <yudha@bonbon.net>) |
Ответы |
Re: Can not deleted all record
|
Список | 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@bonbon.net> wrote: > > > From: "Yudha Setiawan" <yudha@bonbon.net> > > To: <pgsql-admin@postgresql.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 > > ------------------------------------
В списке pgsql-admin по дате отправления: