Postgres Pro
Downloads
Home   >   mailing lists

Re: URGENT: How to change ON CASCADE RESTRICT to DELETE? - Mailing list pgsql-general

From Kallol Nandi
Subject Re: URGENT: How to change ON CASCADE RESTRICT to DELETE?
Date
Msg-id NBEDKIHMDKLGDCDIJLMMKECFCBAA.kallol.nandi@indussoft.com
Whole thread Raw
In response to URGENT: How to change ON CASCADE RESTRICT to DELETE?  (Robert <robert@robert.cz>)
List pgsql-general
Tree view 
Drop constraint is there within Alter Table command.

Regards,
Kallol.

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Robert
Sent: Wednesday, July 02, 2003 12:44 PM
To: pgsql-general@postgresql.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

pgsql-general by date:

Previous
From: Kaare Rasmussen
Date:
Subject: Re: New position and new location
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: Duplicate key insert question