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

[Michael S. <m...@sa...>]

Hi Ricardo,

I looked into the issue and you're correct, rules are not created for =20=

the version tables.  I've reopened bug 257 and will take a crack at =20
fixing this today.  It was a known (but forgotten) issue in the =20
codebase that was non-trivial to fix, but with another change made a =20
while back should now be relatively straight forward.

--Mike

On Jan 3, 2006, at 5:33 AM, Ricardo Balbi wrote:

> Steve,
>   I think that the problem is the lack of rules for the views of =20
> xxxVer schemas, as this message:
>
> sqlExec: INSERT INTO DoTSVer.SourceVer select v.*,69,now(),29 from =20
> 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 =20
> 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 =20=

> solve the
> >problem about "Cannot insert on a view" when running ISF.
> >
> >We have a version of ISF working in a previous gus installation =20
> (some months
> >ago)
> >when this plugin were in beta version yet. So, we got the rules =20
> from that dots
> >schema and put them in our deficient gus (ISF problem). But the =20
> 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 =20=

> log files
> >for problems?  Stop!  Download the new AJAX search engine that makes
> >searching your log files as easy as surfing the  web.  DOWNLOAD =20
> 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 =20
> log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD =20
> 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
>