Received: from dns2.e-scape.net ([216.13.52.3])
	by hub.org (8.9.3/8.9.3) with ESMTP id KAA71932
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 31 Aug 1999 10:54:46 -0400 (EDT)
	(envelope-from robertC@opmr.com)
Received: from optimal-robotics.com (optimal.e-scape.net [216.13.51.254])
	by dns2.e-scape.net (8.8.8/8.8.8) with ESMTP id KAA03741
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 31 Aug 1999 10:55:34 -0400 (EDT)
Received: from doom.optimal-robotics.com [10.10.10.1] by optimal-robotics.com
	[10.10.10.242] with SMTP (MDaemon.v2.83t.R)
	for <pgsql-interfaces@postgreSQL.org>; Tue, 31 Aug 1999 10:54:10 -0400
Received: by DOOM with Internet Mail Service (5.5.2448.0)
	id <RSART9G7>; Tue, 31 Aug 1999 10:46:42 -0400
Message-ID: <91E49E736688D21185F500A0C985C705156DAB@DOOM>
From: Robert Carbonari <robertC@opmr.com>
To: rbrooks@utdallas.edu, Tatsuo Ishii <t-ishii@sra.co.jp>
Cc: Thomas Lockhart <lockhart@alumni.caltech.edu>,
	pgsql-interfaces@postgreSQL.org
Subject: RE: [INTERFACES] How do I drop a column from a table?
Date: Tue, 31 Aug 1999 10:46:40 -0400
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2448.0)
Content-Type: text/plain
X-MDaemon-Deliver-To: pgsql-interfaces@postgreSQL.org
X-Return-Path: robertC@opmr.com
Reply-To: robertC@opmr.com

Thank you all very much!

> -----Original Message-----
> From:	Rusty Brooks [SMTP:rbrooks@utdallas.edu]
> Sent:	Tuesday, August 31, 1999 10:40 AM
> To:	Tatsuo Ishii
> Cc:	Thomas Lockhart; robertC@opmr.com; pgsql-interfaces@postgreSQL.org
> Subject:	Re: [INTERFACES] How do I drop a column from a table?
> 
> On Tue, 31 Aug 1999, Tatsuo Ishii wrote:
> 
> ==>But this method might lose some characteristics such as primary key,
> ==>unique constraints, no?
> 
> I'm not sure, but if it does you can add them back with unique indexes.  I
> also think you can add these attributes back with an alter table combined
> with a CONTSTRAINT x PRIMARYKEY(col)
> 
>   ~~~~~~
>   |    |         Rusty Brooks
>   |c--OD         The University of Texas at Dallas
>   |    _)        Computer Science Dept.
>   |    |          
>   |-.  |         http://www.utdallas.edu/~rbrooks
>  /   `-#  /A
> / /_|..`#.J/     Statisticians probably do it.
> 
> Better by far you should forget and smile than that you should remember
> and be sad.
> 
> If a picture is worth a thousand words, then television must be worth
> 30,000 words per second.
> 	-- Rusty Brooks
>