Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TABLE DROP COLUMN - Mailing list pgsql-novice

From Tom Lane
Subject Re: ALTER TABLE DROP COLUMN
Date
Msg-id 27820.1046900280@sss.pgh.pa.us
Whole thread Raw
In response to ALTER TABLE DROP COLUMN  (glenn <vmstech@tpg.com.au>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Kevin Coyner
Date:
Subject: drop table if exists
Next
From: "Jay G. Scott"
Date:
Subject: PQunescapeBytea problem--what am i doing wrong?