pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedDELETE command is getting blocked
2+ messages / 2 participants
[nested] [flat]
* DELETE command is getting blocked
@ 2002-10-12 11:02 Bhuvan A <bhuvansql@myrealbox.com>
0 siblings, 1 reply; 2+ messages in thread
From: Bhuvan A @ 2002-10-12 11:02 UTC (permalink / raw)
To: pgsql-sql
Hi,
I am using 7.2.
I have problem in deleting records from a particular table in my database.
Say, if the DELETE command results deleting 10 records, the command is
blocked at the end and is not returning. FYI, that table donot have any
triggers/constraints/rules on delete. I have checked whether its due to
the same table access by some other client, but it is not so. No other
process is accessing this table by that time.
Infact i am able to repeat the problem. To make sure, i wrote a plpgsql
and tried deleting these 10 records one by one in a for loop. There too it
is blocked for infinite time, after deleting the last record. what would
be the problem? Is the table corrupted?
FYI, table has a primary key which is referred from different tables.
Anyhow i have deleted records from foreign key tables, before deleting
from the primary key table.
I am lucky if i have given enough information, you required. If not please
get me back. It is quite urgent. Please..
TIA.
regards,
bhuvaneswaran
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: DELETE command is getting blocked
@ 2002-10-12 14:57 Stephan Szabo <sszabo@megazone23.bigpanda.com>
parent: Bhuvan A <bhuvansql@myrealbox.com>
0 siblings, 0 replies; 2+ messages in thread
From: Stephan Szabo @ 2002-10-12 14:57 UTC (permalink / raw)
To: Bhuvan A <bhuvansql@myrealbox.com>; +Cc: pgsql-sql
On Sat, 12 Oct 2002, Bhuvan A wrote:
> I am using 7.2.
>
> I have problem in deleting records from a particular table in my database.
> Say, if the DELETE command results deleting 10 records, the command is
> blocked at the end and is not returning. FYI, that table donot have any
> triggers/constraints/rules on delete. I have checked whether its due to
> the same table access by some other client, but it is not so. No other
> process is accessing this table by that time.
>
> Infact i am able to repeat the problem. To make sure, i wrote a plpgsql
> and tried deleting these 10 records one by one in a for loop. There too it
> is blocked for infinite time, after deleting the last record. what would
> be the problem? Is the table corrupted?
>
> FYI, table has a primary key which is referred from different tables.
> Anyhow i have deleted records from foreign key tables, before deleting
> from the primary key table.
If it's referred from other tables, then it does have triggers on delete.
It's probably the constraint trigger that's blocking, but that should only
occur if something was modifying one of the foreign key tables at the
same time. You might want to turn on query logging to get a good idea
of what's going on.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-10-12 14:57 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-12 11:02 DELETE command is getting blocked Bhuvan A <bhuvansql@myrealbox.com>
2002-10-12 14:57 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox