Select * from pg_rules ? -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] 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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]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/
