On Tue, Jul 01, 2003 at 02:35:48 -0700,
Rudy Koento <rudy_koento(at)yahoo(dot)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.