Thread: Updating views
Hi,
I have read up on the techdocs regarding updating or inserting data to a data through views. I am combining 2 tables and to the user this may appear as one table through the use of views. However, I have problems letting users perform updates,inserts or deletes through views.
I am running Postgresql 7.3.3 on a Redhat Linux 9.0.
1. Such operations are performed through the use of Microsoft Access, whereby I have encountered errors where it asks me to create a rule to do instead nothing. When I created the rule, it says no current record.
2. After reading up the techdocs, I finally was able to perform updates on the first table but not the second. When I updated data on the second table, it disappears the next time I open up Access.
Does anyone has a better idea on how to get around this as I want the users to see only 1 table and manage that only one table? The techdocs was helpful but it only talked about updating through 1 view created on 1 table. Hence, my various attempts proved futile.
Regards,
Lim Seng