Re: CREATE/DROP OPERATOR CLASS

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: CREATE/DROP OPERATOR CLASS
Date: 2002-07-22 15:11:41
Message-ID: 28300.1027350701@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> writes:
> Hmmm...does this mean that there is any situation in which there would be a
> cascade delete of a _column_?

You bet. That's why we need DROP COLUMN done ;-)

> ie. If you drop the domain a column is using with the cascade option, will
> the column get dropped automatically? That doesn't sound like very nice
> behaviour...?

What did you think CASCADE was for?

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-07-22 15:18:55 Re: Demo patch for DROP COLUMN
Previous Message Vince Vielhaber 2002-07-22 09:48:03 Re: pgbash-2.4a.2 released