also, if you open up psql, you can type "\d <view_name>" and it will tell you everything about the view. --- Adam Rich <adam.r@xxxxxxxxxxxxx> wrote: > > 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/ > >
