Re: 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