Select * from pg_rules ?
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.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@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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/