gusdev-gusdev

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

[<fab...@de...>]

Hello all,

We've tried, unsuccessfully, all sugestions to fix ISF problem.=20

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 mon=
ths
ago)
when this plugin were in beta version yet. So, we got the rules from that=
 dots
schema and put them in our deficient gus (ISF problem). But the same prob=
lem
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.

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

[Steve F. <sfi...@pc...>]

fabricio-

perhaps we can set up a time to talk about this on the phone.  what=20
times are you available next week?

steve

fab...@de... wrote:

>Hello all,
>
>We've tried, unsuccessfully, all sugestions to fix ISF problem.=20
>
>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 mo=
nths
>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 pro=
blem
>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 f=
iles
>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
> =20
>

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
>

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
>