Re: Problems With VIEWS

Select * from pg_rules ?

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] 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 'custom' functions -- where/how can
you
view the RULES in Postgres?

I use CaseStudio to generate my Schemas/create my Rules and then import
them
into Postgres to create my tables and views - is there anyway for me to
view
them in Postgres to verify that they got imported correctly? I can view
the
.sql files that I imported to verify the CREATE functions, etc., but
when I
search these files, the "CREATE RULE" commands are not in there...

Thanks much,
-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 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 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 inserted.
All of the New.[field_names] in the insert statement must be view
fieldnames
not table fieldnames.

Regards,
Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/