Thread: dropped columns
Hi all I had this problem a while back, which I posted in the novices section: --- 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. ----- This suggestion was made in reply: ---- You need a newer version of the ODBC driver (one that understands about dropped columns). ---- However, as far as I can tell I'm using 7.2.5 which is the latest (according to upgrade wizard pgadmin). Any hints?
I have had success using the snapshot dll from the following address: http://www.geocities.jp/inocchichichi/psqlodbc/ Save your old psqlodbc.dll(found in C:\Windows\System) under new name just in case and copy snapshot psqlodbc.dll into its place. On Tuesday 01 April 2003 06:50 pm, glenn wrote: > Hi all > I had this problem a while back, which I posted in the novices section: > --- > 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. > ----- > > This suggestion was made in reply: > ---- > You need a newer version of the ODBC driver (one that understands about > dropped columns). > ---- > However, as far as I can tell I'm using 7.2.5 which is the latest > (according to upgrade wizard pgadmin). Any hints? > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org