Re: Problems With VIEWS - Mailing list pgsql-general

From Richard Broersma Jr
Subject Re: Problems With VIEWS
Date
Msg-id 826016.26252.qm@web31809.mail.mud.yahoo.com
Whole thread Raw
In response to Problems With VIEWS  ("Jeanna Geier" <jgeier@apt-cafm.com>)
Responses Re: Problems With VIEWS  ("Jeanna Geier" <jgeier@apt-cafm.com>)
List pgsql-general
> 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.

pgsql-general by date:

Previous
From: Walter Vaughan
Date:
Subject: Re: Trying to load MySQL data
Next
From: "Jeanna Geier"
Date:
Subject: Re: Problems With VIEWS