RHDB just sits and does nothing? - Mailing list pgsql-admin

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