Skip site navigation (1) Skip section navigation (2)

cannot remove column + no error msg

From: Bram Kuijper <a(dot)l(dot)w(dot)kuijper(at)rug(dot)nl>
To: pgsql-novice(at)postgresql(dot)org
Subject: cannot remove column + no error msg
Date: 2006-12-11 15:11:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hi all,

sorry for the clutter, but cannot find a good answer to this problem in 
the mailinglist archives:

If I execute either of both commands (I run postgresql 8.1.4 on Ubuntu 

# ALTER TABLE table_name DELETE COLUMN column
# ALTER TABLE table_name DROP COLUMN column

nothing happens... if I do

# \d table_name,

all columns are still nicely present, like nothing happened at all.

In the pgsql-docs, I found that columns are not physically removed but 
made only unvisible to SQL commands. However, I DO want to physically 
remove those columns, since they are empty anyway. But apparently no way 
how to do it. Does anybody knows a way how to proceed?

Second question is related to that. If I type any bogus (e.g. 
"sflkjdslkfj") onto the psql commandline, PostgreSQL remains silent. 
This is nice in some cases, but is there a way to let it do some error 
checking on the bogus I type? I am not used to commandlines that just 
swallow text and don't warn for any errors, giving me the idea that the 
it is apparently correct. Anybody any idea to change some configuration 

thanks in advance,


pgsql-novice by date

Next:From: A. KretschmerDate: 2006-12-11 15:43:54
Subject: Re: cannot remove column + no error msg
Previous:From: KarebacDate: 2006-12-10 12:17:04
Subject: Re: psql command line question regarding function of single

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group