| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Rod Taylor" <rbt(at)zort(dot)ca> |
| Cc: | "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: CREATE/DROP OPERATOR CLASS |
| Date: | 2002-07-22 02:13:31 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOGEDOCDAA.chriskl@familyhealth.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2002-07-22 02:22:40 | Re: Demo patch for DROP COLUMN |
| Previous Message | Rod Taylor | 2002-07-22 02:00:39 | Re: CREATE/DROP OPERATOR CLASS |