Re: [ADMIN] ALTER table taking ages...

2004-06-08 Thread Gaetano Mendola
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

Re: [ADMIN] ALTER table taking ages...

2004-02-27 Thread mallah
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

Re: [ADMIN] ALTER table taking ages...

2004-02-27 Thread Tom Lane
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

[ADMIN] ALTER table taking ages...

2004-02-26 Thread Rajesh Kumar Mallah
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_