updating data but the constraint is set "immediate"

From: Rudy Koento <rudy_koento(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: updating data but the constraint is set "immediate"
Date: 2003-07-01 09:35:48
Message-ID: 20030701093548.42017.qmail@web41606.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Can anyone help?

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message javier garcia - CEBAS 2003-07-01 09:59:50 numeric formats in SELECT
Previous Message Hannu Krosing 2003-07-01 07:23:58 Re: [HACKERS] PlPython