>> hello all!
>>
>> how to drop columns in postgresql?
>
> according to pg expert Mike, hindi pwede. Alam ko hindi rin pwede sa
> Oracle.
Yep... Learned in databases class that dropping tables as a feature has
been "dropped" or probably never implemented in the first place was
because of the problems that'd arise when you tables are dropped, namely
that of broken relations and the like.
Renaming is probably safer in that the developers can handle this within
the RDBMS and have all referencing tables/views/queries etc change as
well (cascade -- hehe).
But dropping? Hmm... Perhaps drop column --> warn about possible
screw-ups --> confirm --> set null referencing stuff?
--------------------------------------
Gino LV. Ledesma
Ateneo Cervini-Eliazo Networks (ACENT)
email : [EMAIL PROTECTED]
web : http://cersa.admu.edu.ph/
phone : (63)(2) 426-6001 ext. 5925/5904
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
