Search Postgresql Archives

Re: Problems With VIEWS

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux