Thread: ALTER TABLE DROP COLUMN

ALTER TABLE DROP COLUMN

From
glenn
Date:
Hi All
I with 7.3.2 I used
ALTER TABLE job DROP x
To drop column x
The result is that column x is now a replaced by a column called
"........pg.dropped.4........."
exists in its place, and now my odbc connections won't touch the table.
I also can't seem to drop or rename this column. I could rename the
table, and do create table as, but I'd like to know if there is
something else I can do use drop column effectively.

Glenn






Re: ALTER TABLE DROP COLUMN

From
Tom Lane
Date:
glenn <vmstech@tpg.com.au> writes:
> I with 7.3.2 I used
> ALTER TABLE job DROP x
> To drop column x
> The result is that column x is now a replaced by a column called
> "........pg.dropped.4........."
> exists in its place, and now my odbc connections won't touch the table.

You need a newer version of the ODBC driver (one that understands about
dropped columns).

            regards, tom lane

Re: ALTER TABLE DROP COLUMN

From
Miernik
Date:
In article <27820.1046900280@sss.pgh.pa.us>, Tom Lane wrote:

>> The result is that column x is now a replaced by a column called
>> "........pg.dropped.4........."
>> exists in its place, and now my odbc connections won't touch the table.
>
> You need a newer version of the ODBC driver (one that understands about
> dropped columns).

I see the same thing when I access my table with phppgadmin 2.4.1-2
from Debian, Isn't there any way to just get rid of the dropped column
remains completely? Just as if the column never existed?

Something else then dumping the database, editing the dump file with a
text editor to delete the unnessesary column and restoring the
database.

--
Miernik