Re: URGENT: How to change ON CASCADE RESTRICT to DELETE?

From: "Kallol Nandi" <kallol(dot)nandi(at)indussoft(dot)com>
To: "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: URGENT: How to change ON CASCADE RESTRICT to DELETE?
Date: 2003-07-02 08:02:24
Message-ID: NBEDKIHMDKLGDCDIJLMMKECFCBAA.kallol.nandi@indussoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Drop constraint is there within Alter Table command.

Regards,
Kallol.

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Robert
Sent: Wednesday, July 02, 2003 12:44 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] URGENT: How to change ON CASCADE RESTRICT to DELETE?

Hi,

how can I change ON CASCADE RESTRICT to ON CASCADE DELETE? I need to
do it on my production database now (client is really complaining...)
and I dont see any DROP CONSTRAINT in the docs - whats the right and/or
simplest way? Thanks a lot

- Robert

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-07-02 08:05:20 Re: Duplicate key insert question
Previous Message Kaare Rasmussen 2003-07-02 07:56:13 Re: New position and new location