Drop column and Access
От | Adrian Klaver |
---|---|
Тема | Drop column and Access |
Дата | |
Msg-id | 200212031905.51944.aklaver@attbi.com обсуждение исходный текст |
Ответы |
Re: Drop column and Access
|
Список | pgsql-general |
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@attbi.com
В списке pgsql-general по дате отправления: