Thread: can't relink from MS access after dropping field
After dropping a field in a postgres table this morning (alter table tstudents drop company_id) I now get an error message from Access when I try to link to that table: .........pg.dropped.31........ is not a valid name etc. In the get external data>link tables>ODBC databases() dialog box the name of the table looks normal: public_tstudents using ocbc driver 7.2.5.0 I am hoping that after vacuum runs tonight the problem will go away; in the meantime I will use a backup copy of my access app which has the original link intact and still works. Any ideas? Thanks Fred Parkinson Association of Bay Area Governments
--- Fred Parkinson <FredP@abag.ca.gov> escribió: > After dropping a field in a postgres table this > morning > (alter table tstudents drop company_id) > I now get an error message from Access when I try to > link to that > table: > > .........pg.dropped.31........ > is not a valid name etc. > That's because postgresql actually doesn't remove the column it just rename it and mark it as dropped. when access try to see the table structure it doesn't know it has to ask if the column has been marked as dropped and try to show it but the new column name for the dropped column is not a valid name so it rejects and show you the error above. the solution i found: pg_dump/pg_restore the base regards, Jaime Casanova _________________________________________________________ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com
Hi, you need to refresh the linked table. Under the tables section, right click on the table then click "linked table Manager". Select the table again and click refresh. Any time you make a change to a table in postgres, you must then refresh it in MS Access or strange things start to happen. Fred Parkinson wrote: >After dropping a field in a postgres table this morning >(alter table tstudents drop company_id) >I now get an error message from Access when I try to link to that >table: > >.........pg.dropped.31........ >is not a valid name etc. > >In the get external data>link tables>ODBC databases() dialog box the >name of the table looks normal: public_tstudents > >using ocbc driver 7.2.5.0 > >I am hoping that after vacuum runs tonight the problem will go away; in >the meantime I will use a backup copy of my access app which has the >original link intact and still works. > >Any ideas? > >Thanks > >Fred Parkinson >Association of Bay Area Governments > >---------------------------(end of broadcast)--------------------------- >TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > >
> -----Original Message----- > From: pgsql-odbc-owner@postgresql.org > [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Fred Parkinson > Sent: 02 December 2004 20:45 > To: pgsql-odbc@postgresql.org > Subject: [ODBC] can't relink from MS access after dropping field > > After dropping a field in a postgres table this morning > (alter table tstudents drop company_id) I now get an error > message from Access when I try to link to that > table: > > .........pg.dropped.31........ > is not a valid name etc. > > In the get external data>link tables>ODBC databases() dialog > box the name of the table looks normal: public_tstudents > > using ocbc driver 7.2.5.0 > > I am hoping that after vacuum runs tonight the problem will > go away; in the meantime I will use a backup copy of my > access app which has the original link intact and still works. > > Any ideas? That is quite an old version of the ODBC driver. Newer ones should hide the dropped columns properly. Regards, Dave.