02 AM
To: Richard Broersma Jr
Cc: Jeanna Geier; Adam Rich; pgsql-general
Subject: Re: [GENERAL] Problems With VIEWS
On Thu, 11 Jan 2007 06:36:34 -0800 (PST), Richard Broersma Jr
<[EMAIL PROTECTED]> wrote:
>
> Either way. I like to create sql files with all of the DDL for creati
Bernd Helmle wrote:
On Thu, 11 Jan 2007 06:36:34 -0800 (PST), Richard Broersma Jr <[EMAIL
PROTECTED]> wrote:
Either way. I like to create sql files with all of the DDL for creating
the view and rules.
Overtime, if I need to change my view or reconfigure the rules, I can edit
my sql file a
On Thu, 11 Jan 2007 06:36:34 -0800 (PST), Richard Broersma Jr <[EMAIL
PROTECTED]> wrote:
>
> Either way. I like to create sql files with all of the DDL for creating
> the view and rules.
> Overtime, if I need to change my view or reconfigure the rules, I can edit
> my sql file and then
> cal
> So, herein probably lies my problem with the "Cannont insert into a view"
> error I'm getting anytime I'm attempting to access it from my program -
> there are no rules set up for them, right?
Correct, without insert rules you will not be able to add new records to the
underlying tables of
a v
gt; Select * from pg_rules ?
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Jeanna Geier
> Sent: Wednesday, January 10, 2007 5:43 PM
> To: Richard Broersma Jr; pgsql-general
> Subject: Re: [GENERAL] Problems With VIEWS
&
TED] On Behalf Of Jeanna Geier
> Sent: Wednesday, January 10, 2007 5:43 PM
> To: Richard Broersma Jr; pgsql-general
> Subject: Re: [GENERAL] Problems With VIEWS
>
>
> I guess I have a general question regarding Postgres and RULES --
> relative
> newbie here, especially with these
Select * from pg_rules ?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeanna Geier
Sent: Wednesday, January 10, 2007 5:43 PM
To: Richard Broersma Jr; pgsql-general
Subject: Re: [GENERAL] Problems With VIEWS
I guess I have a general question
Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Richard Broersma
Jr
Sent: Wednesday, January 10, 2007 5:04 PM
To: Jeanna Geier; pgsql-general
Subject: Re: [GENERAL] Problems With VIEWS
> 2007-01-10 16:45:33 ERROR: cannot insert into a view
> 2007-01-10 1
> 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.
Also, I see you have this field in your insert rule:
new.upgrade_date
but I see so upgrade_date in you view's definition. What exactly do you intend
to be
OTECTED] 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
> 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
Hello List-
I'm having some problems with Views that I'd really appreciate some feedback
and ideas on...
I have a Java program that we're developing that's a CAD/blueprint program
that allows the user to select a room in a building and attach information
from the database about that room (i.e. ag
12 matches
Mail list logo
