Re: ALTER TABLE DROP COLUMN

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: glenn <vmstech(at)tpg(dot)com(dot)au>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: ALTER TABLE DROP COLUMN
Date: 2003-03-05 21:38:00
Message-ID: 27820.1046900280@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

glenn <vmstech(at)tpg(dot)com(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mr.F 2003-03-06 10:51:28 New Interface for Win
Previous Message Kevin Coyner 2003-03-05 19:09:03 drop table if exists