Programs used -Postgres 7.3,SuSE 7.2,psqlODBC 7.02.00.04,Access95,97,Win95,98.
I have a Postgres database running on a Linux server. I dropped a column on
one of the tables. When I tried to relink the table in Access it complained
it couldn't find the table because of a naming violation. The name had stayed
the same so I was somewhat confused. When I looked at the table via
phpPgAdmin I saw the dropped column with a column name of
...pg.dropped.table7...(as well as I can remember). This explained the naming
violation. The only way I could get Access to see the table was to recreate
by storing the nondropped columns in a temp table dropping the original table
and then restoring the table from the temp table. Is there a way of removing
the reference to the dropped column so less enlightened applications don't
have problems?
Thank you
Adrian Klaver
aklaver(at)attbi(dot)com