> I get an error: "Cannot insert into a view." I
> haven't even viewed it, much less attempted to insert into it; and let's say
> I could get into it, is there anything wrong with my ON INSERT RULE that
> would throw this error? Because on several of my other views, I can get
> into them, but not insert into them when it appears that my ON INSERT
> statements are correct.
Turn on Statement logging in you postgresql.conf file. Try and insert and after it fails examine
the insert statement and notice the error message.
REgards,
Richard Broersma Jr.