Re: CREATE/DROP OPERATOR CLASS - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: CREATE/DROP OPERATOR CLASS
Date
Msg-id GNELIHDDFBOCMGBFGEFOGEDOCDAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: CREATE/DROP OPERATOR CLASS  (Rod Taylor <rbt@zort.ca>)
List pgsql-hackers
> More obvious if you drop a user defined type that a column was using. Or
> the functions that the user defined type depended on to import / export
> data then there is no method to insert or extract information from that
> column -- or more to the point any tuple within that table.
> 
> This is what CASCADE does.  Ensures the structure is clean much like
> foreign keys and constraints help keep data clean.
> 
> RESTRICT is there for those who don't fully understand the structure. 
> Cautiously test the waters to see what else you may be affecting first.


Yeah, I guess you're right!

Chris



pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: CREATE/DROP OPERATOR CLASS
Next
From: SAKAIDA Masaaki
Date:
Subject: pgbash-2.4a.2 released