Re: updating data but the constraint is set "immediate" - Mailing list pgsql-general

On Tue, Jul 01, 2003 at 02:35:48 -0700,
  Rudy Koento <rudy_koento@yahoo.com> wrote:
> Hi,
>
> I've realised that my tables' constraint was set to
> IMMEDIATE.  So, when I update one table, there's error
> because of referential integrity.  Reading the docs, I
> read that SET CONSTRAINTS has no effect on IMMEDIATE
> (and I've confirmed that by trying it out).
>
> Is there anyway I can circumvent this?  I remembered I
> can delete using pgAdminII.  However, I don't have a
> windows box now, and therefore I can't use pgAdminII.

You can use alter table to drop the constraint and then to add the corrected
constraint. I am not sure if this was available prior to 7.3.