Thanks for the answers. I recreated the views. Did not realize when you
renamed a column, it also changed the views.
Art
Robby Russell wrote:
On Tue, 2005-02-08 at 16:37 -0800, Art Fore wrote:
Using phppgadmin, I tried tropping a column in a table. I comes back to
try DROP .. CASCADE. Went into
On Tue, 2005-02-08 at 16:37 -0800, Art Fore wrote:
> Using phppgadmin, I tried tropping a column in a table. I comes back to
> try DROP .. CASCADE. Went into psql and typed the following,
>
> ALTER TABLE "MPC" DROP COLUMNG do_not_use CASCADE
>
> It appeared to work but did not drop the column.
Hi Art,
On Feb 8, 2005, at 7:37 PM, Art Fore wrote:
ALTER TABLE "MPC" DROP COLUMNG do_not_use CASCADE
It appeared to work but did not drop the column. What is the
dprocedure for dropping a column? an anyone point me to a document
that tells EXACTLY how to do this? Also, how do you find out the
Using phppgadmin, I tried tropping a column in a table. I comes back to
try DROP .. CASCADE. Went into psql and typed the following,
ALTER TABLE "MPC" DROP COLUMNG do_not_use CASCADE
It appeared to work but did not drop the column. What is the dprocedure
for dropping a column? an anyone point m