[EMAIL PROTECTED] writes: >"Gino LV.Ledesma" wrote: >> >> >> 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. > >The question was about dropping columns. DROP TABLE is and has always >been a SQL. Referential integrity is often implemented via database >triggers, so when a table with a primary key referenced from other >tables is dropped, the trigger(s) is/are dropped as well. This is true but you have to manually deal with the "sequences" (usually created with tables using "serial" data types in PostgreSQL. >The database >remains consistent. > sherwin _ 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]
