Re: Problems With VIEWS

From: "Jeanna Geier" <jgeier(at)apt-cafm(dot)com>
To: "Richard Broersma Jr" <rabroersma(at)yahoo(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problems With VIEWS
Date: 2007-01-10 22:52:18
Message-ID: FBEGJLLJBCOMCDBJHIMEOENKCCAA.jgeier@apt-cafm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma Jr 2007-01-10 23:04:05 Re: Problems With VIEWS
Previous Message garrettmoore@gmail.com 2007-01-10 22:51:01 Re: Trying to load MySQL data