Re: [GUSDEV] RES: Re: Inserting Sequence Features - Problem with a big reference

[Ricardo B. <rb...@gm...>]

Steve,
  I think that the problem is the lack of rules for the views of xxxVer
schemas, as this message:

sqlExec: INSERT INTO DoTSVer.SourceVer select v.*,69,now(),29 from
DoTS.Source v where v.na_feature_id =3D ?
  bindValues (15)
DBD::Pg::st execute failed: ERROR:  cannot insert into a view
HINT:  You need an unconditional ON INSERT DO INSTEAD rule.

  Would you have an file with the creation of these rules?
  In my installation there are 76 views for dotsver, 24 views for protver,
30 views for radver and 4 views for studyver.

Ricardo.

2005/12/30, Steve Fischer <sfi...@pc...>:
>
> fabricio-
>
> perhaps we can set up a time to talk about this on the phone.  what
> times are you available next week?
>
> steve
>
> fab...@de... wrote:
>
> >Hello all,
> >
> >We've tried, unsuccessfully, all sugestions to fix ISF problem.
> >
> >Swicthing the rules from gus schema to those in objects.sql didn't solve
> the
> >problem about "Cannot insert on a view" when running ISF.
> >
> >We have a version of ISF working in a previous gus installation (some
> months
> >ago)
> >when this plugin were in beta version yet. So, we got the rules from tha=
t
> dots
> >schema and put them in our deficient gus (ISF problem). But the same
> problem
> >persists.
> >
> >Now we have no idea about what we can do to solve this problem.
> >
> >If you can do something to solve this bug we would be so grateful.
> >
> >Thanks in advance,
> >
> >Fabr=EDcio.
> >
> >----------------------------------------------------------------
> >This message was sent using IMP, the Internet Messaging Program.
> >
> >
> >-------------------------------------------------------
> >This SF.net email is sponsored by: Splunk Inc. Do you grep through log
> files
> >for problems?  Stop!  Download the new AJAX search engine that makes
> >searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> >http://ads.osdn.com/?ad_idv37&alloc_id=16865&op=CCk
> >_______________________________________________
> >Gusdev-gusdev mailing list
> >Gus...@li...
> >https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
> >
> >
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log
> files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_idv37&alloc_id=16865&opclick
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>