X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 51A15D1B229 for ; Wed, 9 Jun 2004 04:14:47 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 19494-08 for ; Wed, 9 Jun 2004 07:14:40 +0000 (GMT) Received: from www.postgresql.com (www.postgresql.com [200.46.204.209]) by svr1.postgresql.org (Postfix) with ESMTP id 05CC9D1B18F for ; Wed, 9 Jun 2004 04:14:34 -0300 (ADT) Received: from gw02.mail.saunalahti.fi (gw02.mail.saunalahti.fi [195.197.172.116]) by www.postgresql.com (Postfix) with ESMTP id 18EE5CF4C03 for ; Wed, 9 Jun 2004 04:14:33 -0300 (ADT) Received: from www.claymountain.com (crash.claymountain.com [62.142.127.138]) by gw02.mail.saunalahti.fi (Postfix) with SMTP id 9EF9429875 for ; Wed, 9 Jun 2004 10:13:47 +0300 (EEST) Received: from 195.197.242.66 (SquirrelMail authenticated user mos) by www.claymountain.com with HTTP; Wed, 9 Jun 2004 10:06:30 +0300 (EEST) Message-ID: <64169.195.197.242.66.1086764790.squirrel@www.claymountain.com> Date: Wed, 9 Jun 2004 10:06:30 +0300 (EEST) Subject: RHDB just sits and does nothing? From: "Mauri Sahlberg" To: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.1 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=PRIORITY_NO_NAME X-Spam-Level: X-Archive-Number: 200406/102 X-Sequence-Number: 13762 Hi, What an earth I am doing wrong? I am trying to delete about 6500 rows and I am the only user connected to the database and it just sits there and does nothing? rahaks=# select count(*) from tilikartta where yritys=18231413; count ------- 6347 (1 row) rahaks=# explain delete from tilikartta where yritys=18231413; QUERY PLAN -------------------------------------------------------------- Seq Scan on tilikartta (cost=0.00..500.23 rows=249 width=6) Filter: (yritys = 18231413) (2 rows) rahaks=# begin foo rahaks-# ; ERROR: parser: parse error at or near "foo" at character 7 rahaks=# begin; BEGIN rahaks=# set constraints all deferred; SET CONSTRAINTS rahaks=# delete from tilikartta where yritys=18231413; Logs are fed to syslog and there I can see the following: Jun 9 10:02:11 pihsi postgres[31547]: [19] LOG: query: select count(*) from tilikartta where yritys=18231413; Jun 9 10:02:11 pihsi postgres[31547]: [20] LOG: duration: 0.041401 sec Jun 9 10:02:33 pihsi postgres[31547]: [21] LOG: query: explain delete from tilikartta where yritys=18231413; Jun 9 10:02:33 pihsi postgres[31547]: [22] LOG: duration: 0.000781 sec Jun 9 10:02:41 pihsi postgres[31547]: [23] LOG: query: begin foo Jun 9 10:02:41 pihsi postgres[31547]: [24] ERROR: parser: parse error at or near "foo" at character 7 Jun 9 10:02:44 pihsi postgres[31547]: [25] LOG: query: begin; Jun 9 10:02:44 pihsi postgres[31547]: [26] LOG: duration: 0.000181 sec Jun 9 10:02:51 pihsi postgres[31547]: [27] LOG: query: set constraints all deferred; Jun 9 10:02:51 pihsi postgres[31547]: [28] LOG: duration: 0.000205 sec Jun 9 10:03:04 pihsi postgres[31547]: [29] LOG: query: delete from tilikartta where yritys=18231413; It is now 10:09 local time and it still sits there and does nothing? Table "public.tilikartta" Column | Type | Modifiers ------------+------------------------+----------- numero | integer | not null tililaji | smallint | not null kielikoodi | smallint | not null yritys | integer | not null selite | character varying(255) | not null tilimalli | character varying(255) | Indexes: pk_tilikartta primary key btree (numero, tililaji, kielikoodi, yritys) Foreign Key constraints: fk_tilikartta_yritys FOREIGN KEY (yritys) REFERENCES yritys(numero) ON UPDATE NO ACTION ON DELETE NO ACTION, fk_tilikartta_tilikarttamallit FOREIGN KEY (tilimalli) REFERENCES tilikarttamallit(nimi) ON UPDATE NO ACTION ON DELETE NO ACTIO psql (PostgreSQL) 7.3.6-RH contains support for command-line editing rh-postgresql-server-7.3.6-1