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@postgresql.org
[mailto:pgsql-general-owner@postgresql.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
