Rajesh Kumar Mallah wrote:
Greetings!
It takes ages to drop a constraint from one of my tables
[ table details at the end ] I cannot insert into it also.
I know pg_dump is not running and no other query is accessing the table.
Can anyone help me debugging this problem? Can anyone explain the
foll
Thanks very much,
Unfortunately i restarted the postmaster
as we had to move forward. Since then i have not faced this problem.
I shall post the results next time i face this kind of problem.
Regds
mallah.
> Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
>> It takes ages to drop a constraint
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
> It takes ages to drop a constraint from one of my tables
> [ table details at the end ] I cannot insert into it also.
DROP CONSTRAINT in itself isn't going to take any significant amount of
time. The only plausible explanation is that some other s
Greetings!
It takes ages to drop a constraint from one of my tables
[ table details at the end ] I cannot insert into it also.
I know pg_dump is not running and no other query is accessing the
table.
Can anyone help me debugging this problem? Can anyone explain the
following entires in pg_