views in 8.0

Started by Jason Tesserover 21 years ago2 messagesgeneral
Jump to latest
#1Jason Tesser
JTesser@nbbc.edu

Can you insert and update data in views in 8.0 I know you cannot in 7.4. I am asking because I want to make new structure for my backend but for legacy apps I need to keep the old sturcture also. I was hoping to use views to accomplish this by making the new structure and give the old apps view with the same name as the old tables. :-) I guess I can also do this by writing alot of rules but that would get messy quick I think.

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Jason Tesser (#1)
Re: views in 8.0

Am Dienstag, 11. Januar 2005 13:43 schrieb Jason Tesser:

Can you insert and update data in views in 8.0 I know you cannot in 7.4.

Views not updatable in 7.4 or in 8.0. You need to write your own update
rules. Nothing has changed in that regard.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/