Thanks, Richard! Doing so produced the following message in my log file: 2007-01-10 16:45:33 ERROR: cannot insert into a view 2007-01-10 16:45:33 HINT: You need an unconditional ON INSERT DO INSTEAD rule. That's why I like this forum, people are so knowledgeable, helpful, and quick to answer! Now, just gotta research this some more and I'll post my solution once it's working so that others who may search may find something helpful in one of my posts as I have in so many others. Thanks again! -Jeanna -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]On Behalf Of Richard Broersma Jr Sent: Wednesday, January 10, 2007 4:32 PM To: Jeanna Geier; pgsql-general Subject: Re: [GENERAL] Problems With VIEWS > 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
