dropping constraints

From: Kevin Kempter <cs_dba(at)consistentstate(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: dropping constraints
Date: 2010-09-02 02:58:05
Message-ID: 201009012058.05142.cs_dba@consistentstate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All;

we have a few not null constraints we want to drop on very large tables.
Unfortunately the drop's are taking hours. Is there a way to drop a not null
constraint via the system catalogs?

Thanks in advance

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2010-09-02 03:20:35 Re: dropping constraints
Previous Message Tom Lane 2010-09-01 21:36:53 Re: Invalid page header