no drop column?!
no drop column?!
От:
Lucas Rockwell <lr@socrates.Berkeley.EDU>
Дата:
bavc=> alter table staff drop column date_created cascade; ERROR: ALTER TABLE / DROP COLUMN is not implemented is this true???!!! i am using PostgreSQL 7.2. -lucas ------------------------ Lucas Rockwell UAS Systems Group 510.642.6465 lr@socrates.berkeley.edu ------------------------
Re: no drop column?!
От:
Jyry Kuukkanen <jyry@neutech.fi>
Дата:
On Sun, 24 Mar 2002, Lucas Rockwell wrote: > bavc=> alter table staff drop column date_created cascade; > ERROR: ALTER TABLE / DROP COLUMN is not implemented > > is this true???!!! i am using PostgreSQL 7.2. > > -lucas Hello lucas Yes, it is true -- with Pgsql 7.3, too. There is a way to get around it, however, but requires creating temp table, selecting, inserting and renaming back to original name. The php user's guide explains this in detail. But there is an easier way to do this, once you heve installed phpPgAdmin (http://phppgadmin.sourceforge.net). phpPgAdmin automates the procedure to create/select/insert/rename to one click. --jq --Jyry C:-( C:-/ C========8-O C8-/ C:-(