• [Info-ingres] drop function error

    From Paul White@21:1/5 to Martin Bowes on Tue Jun 15 19:10:04 2021
    To: info-ingres@lists.planetingres.org

    This is a multi-part message in MIME format.
    try

    alterdb -enable_x100 martydb

    If the database was created with -no_x100 then the drop statement fails.




    On 15/06/2021 6:20 pm, Martin Bowes wrote:

    Hi All,

    In 11.2 we can now do CREATE FUNCTION!

    So as an unprivileged user I created a function in iidbdb, it worked,
    and then I tried to drop it

    drop function helloworld\g

    Executing . . .

    E_US253F X100 statements are disabled for this database or session.

    (Tue Jun 15 09:12:46 2021)

    So I logged in as ingres, connected to iidbdb and did:

    drop function "martinb".helloworld\g

    Executing . . .

    Error message corresponding to 328736 (50420) not found in

    INGRES error file

    ()

    Any ideas on how to drop this bloody thing?

    Martin Bowes


    _______________________________________________
    Info-ingres mailing list
    Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html;
    charset=windows-1252">
    </head>
    <body>
    <p>try <br>
    </p>
    <p>alterdb -enable_x100 martydb <br>
    </p>
    <p>If the database was created with -no_x100 then the drop statement
    fails.</p>
    <br>
    <p><br>
    </p>
    <p><br>
    </p>
    On 15/06/2021 6:20 pm, Martin Bowes wrote:<br>
    <blockquote type="cite"
    cite="mid:d3f45c6c822940b3b5316fa1f6f2b27e@ndph.ox.ac.uk">
    <meta http-equiv="Content-Type" content="text/html;
    charset=windows-1252">
    <meta name="Generator" content="Microsoft Word 15 (filtered
    medium)">
    <style>@font-face
    {font-family:"Cambria Math";
    panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
    {font-family:Calibri;
    panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face
    {font-family:"Lucida Console";
    panose-1:2 11 6 9 4 5 4 2 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
    {margin:0cm;
    margin-bottom:.0001pt;
    font-size:11.0pt;
    font-family:"Calibri",sans-serif;
    mso-fareast-language:EN-US;}a:link, span.MsoHyperlink
    {mso-style-priority:99;
    color:#0563C1;
    text-decoration:underline;}a:visited, span.MsoHyperlinkFollowed
    {mso-style-priority:99;
    color:#954F72;
    text-decoration:underline;}p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
    {mso-style-priority:34;
    margin-top:0cm;
    margin-right:0cm;
    margin-bottom:0cm;
    margin-left:36.0pt;
    margin-bottom:.0001pt;
    font-size:11.0pt;
    font-family:"Calibri",sans-serif;
    mso-fareast-language:EN-US;}span.EmailStyle17
    {mso-style-type:personal-compose;
    font-family:"Calibri",sans-serif;
    color:windowtext;}.MsoChpDefault
    {mso-style-type:export-only;
    font-family:"Calibri",sans-serif;
    mso-fareast-language:EN-US;}div.WordSection1
    {page:WordSection1;}ol
    {margin-bottom:0cm;}ul
    {margin-bottom:0cm;}</style><!--[if gte mso 9]><xml>
    <o:shapedefaults v:ext="edit" spidmax="1026" />
    </xml><![endif]--><!--[if gte mso 9]><xml>
    <o:shapelayout v:ext="edit">
    <o:idmap v:ext="edit" data="1" />
    </o:shapelayout></xml><![endif]-->
    <div class="WordSection1">
    <p class="MsoNormal">Hi All,<o:p></o:p></p>
    <p class="MsoNormal"><o:p></o:p></p>
    <p class="MsoNormal">In 11.2 we can now do CREATE FUNCTION!<o:p></o:p></p>
    <p class="MsoNormal"><o:p></o:p></p>
    <p class="MsoNormal">So as an unprivileged user I created a
    function in iidbdb, it worked, and then I tried to drop it<o:p></o:p></p>
    <p class="MsoNormal"><o:p></o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span
    style="font-size:10.0pt;font-family:&quot;Lucida
    Console&quot;">drop function helloworld\g<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span
    style="font-size:10.0pt;font-family:&quot;Lucida
    Console&quot;">Executing . . .<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span
    style="font-size:10.0pt;font-family:&quot;Lucida
    Console&quot;"><o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span
    style="font-size:10.0pt;font-family:&quot;Lucida
    Console&quot;">E_US253F X100 statements are disabled for
    this database or session.<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span
    style="font-size:10.0pt;font-family:&quot;Lucida
    Console&quot;"> (Tue Jun 15 09:12:46 2021)<o:p></o:p></span></p>
    <p class="MsoNormal"><o:p></o:p></p>
    <p class="MsoNormal">So I logged in as ingres, connected to
    iidbdb and did:<o:p></o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span
    style="font-size:10.0pt;font-family:&quot;Lucida
    Console&quot;">drop function "martinb".helloworld\g<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span
    style="font-size:10.0pt;font-family:&quot;Lucida
    Console&quot;">Executing . . .<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span
    style="font-size:10.0pt;font-family:&quot;Lucida
    Console&quot;"><o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span
    style="font-size:10.0pt;font-family:&quot;Lucida
    Console&quot;">Error message corresponding to 328736
    (50420) not found in<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span
    style="font-size:10.0pt;font-family:&quot;Lucida
    Console&quot;"> INGRES error file<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span
    style="font-size:10.0pt;font-family:&quot;Lucida
    Console&quot;"> ()<o:p></o:p></span></p>
    <p class="MsoNormal"><o:p></o:p></p>
    <p class="MsoNormal">Any ideas on how to drop this bloody thing?<o:p></o:p></p>
    <p class="MsoNormal"><o:p></o:p></p>
    <p class="MsoNormal">Martin Bowes<o:p></o:p></p>
    </div>
    <br>
    <fieldset class="mimeAttachmentHeader"></fieldset>
    <pre class="moz-quote-pre" wrap="">_______________________________________________
    Info-ingres mailing list
    <a class="moz-txt-link-abbreviated" href="mailto:Info-ingres@lists.planetingres.org">Info-ingres@lists.planetingres.org</a>
    <a class="moz-txt-link-freetext" href="https://lists.planetingres.org/mailman/listinfo/info-ingres">https://lists.planetingres.org/mailman/listinfo/info-ingres</a>
    </pre>
    </blockquote>
    </body>
    </html>

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin Bowes@21:1/5 to All on Tue Jun 15 08:20:45 2021
    Hi All,

    In 11.2 we can now do CREATE FUNCTION!

    So as an unprivileged user I created a function in iidbdb, it worked, and then I tried to drop it...

    drop function helloworld\g
    Executing . . .

    E_US253F X100 statements are disabled for this database or session.
    (Tue Jun 15 09:12:46 2021)

    So I logged in as ingres, connected to iidbdb and did:
    drop function "martinb".helloworld\g
    Executing . . .

    Error message corresponding to 328736 (50420) not found in
    INGRES error file
    ()

    Any ideas on how to drop this bloody thing?

    Martin Bowes

    <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
    <meta name="Generator" content="Microsoft Word 15 (filtered medium)"> <style><!--
    /* Font Definitions */
    @font-face
    {font-family:"Cambria Math";
    panose-1:2 4 5 3 5 4 6 3 2 4;}
    @font-face
    {font-family:Calibri;
    panose-1:2 15 5 2 2 2 4 3 2 4;}
    @font-face
    {font-family:"Lucida Console";
    panose-1:2 11 6 9 4 5 4 2 2 4;}
    /* Style Definitions */
    p.MsoNormal, li.MsoNormal, div.MsoNormal
    {margin:0cm;
    margin-bottom:.0001pt;
    font-size:11.0pt;
    font-family:"Calibri",sans-serif;
    mso-fareast-language:EN-US;}
    a:link, span.MsoHyperlink
    {mso-style-priority:99;
    color:#0563C1;
    text-decoration:underline;}
    a:visited, span.MsoHyperlinkFollowed
    {mso-style-priority:99;
    color:#954F72;
    text-decoration:underline;}
    p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
    {mso-style-priority:34;
    margin-top:0cm;
    margin-right:0cm;
    margin-bottom:0cm;
    margin-left:36.0pt;
    margin-bottom:.0001pt;
    font-size:11.0pt;
    font-family:"Calibri",sans-serif;
    mso-fareast-language:EN-US;}
    span.EmailStyle17
    {mso-style-type:personal-compose;
    font-family:"Calibri",sans-serif;
    color:windowtext;}
    .MsoChpDefault
    {mso-style-type:export-only;
    font-family:"Calibri",sans-serif;
    mso-fareast-language:EN-US;}
    @page WordSection1
    {size:612.0pt 792.0pt;
    margin:72.0pt 72.0pt 72.0pt 72.0pt;}
    div.WordSection1
    {page:WordSection1;}
    /* List Definitions */
    @list l0
    {mso-list-id:805700153;
    mso-list-type:hybrid;
    mso-list-template-ids:116666518 134807567 134807577 134807579 134807567 134807577 134807579 134807567 134807577 134807579;}
    @list l0:level1
    {mso-level-tab-stop:none;
    mso-level-number-position:left;
    text-indent:-18.0pt;}
    @list l0:level2
    {mso-level-number-format:alpha-lower;
    mso-level-tab-stop:none;
    mso-level-number-position:left;
    text-indent:-18.0pt;}
    @list l0:level3
    {mso-level-number-format:roman-lower;
    mso-level-tab-stop:none;
    mso-level-number-position:right;
    text-indent:-9.0pt;}
    @list l0:level4
    {mso-level-tab-stop:none;
    mso-level-number-position:left;
    text-indent:-18.0pt;}
    @list l0:level5
    {mso-level-number-format:alpha-lower;
    mso-level-tab-stop:none;
    mso-level-number-position:left;
    text-indent:-18.0pt;}
    @list l0:level6
    {mso-level-number-format:roman-lower;
    mso-level-tab-stop:none;
    mso-level-number-position:right;
    text-indent:-9.0pt;}
    @list l0:level7
    {mso-level-tab-stop:none;
    mso-level-number-position:left;
    text-indent:-18.0pt;}
    @list l0:level8
    {mso-level-number-format:alpha-lower;
    mso-level-tab-stop:none;
    mso-level-number-position:left;
    text-indent:-18.0pt;}
    @list l0:level9
    {mso-level-number-format:roman-lower;
    mso-level-tab-stop:none;
    mso-level-number-position:right;
    text-indent:-9.0pt;}
    ol
    {margin-bottom:0cm;}
    ul
    {margin-bottom:0cm;}
    </style><!--[if gte mso 9]><xml>
    <o:shapedefaults v:ext="edit" spidmax="1026" />
    </xml><![endif]--><!--[if gte mso 9]><xml>
    <o:shapelayout v:ext="edit">
    <o:idmap v:ext="edit" data="1" />
    </o:shapelayout></xml><![endif]-->
    </head>
    <body lang="EN-GB" link="#0563C1" vlink="#954F72">
    <div class="WordSection1">
    <p class="MsoNormal">Hi All,<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">In 11.2 we can now do CREATE FUNCTION!<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">So as an unprivileged user I created a function in iidbdb, it worked, and then I tried to drop it&#8230;<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">drop function helloworld\g<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Executing . . .<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">E_US253F X100 statements are disabled for this database or session.<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">&nbsp;&nbsp;&nbsp; (Tue Jun 15 09:12:46 2021)<o:p></o:p></span></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">So I logged in as ingres, connected to iidbdb and did:<o:p></o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">drop function &quot;martinb&quot;.helloworld\g<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Executing . . .<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Error message corresponding to 328736 (50420)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; not
    found in<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">&nbsp;&nbsp;&nbsp; INGRES error file<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">&nbsp;&nbsp;&nbsp; ()<o:p></o:p></span></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">Any ideas on how to drop this bloody thing?<o:p></o:p></p> <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">Martin Bowes<o:p></o:p></p>
    </div>
    </body>
    </html>

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Paul White@21:1/5 to Martin Bowes on Tue Jun 15 19:23:55 2021
    Copy: info-ingres@lists.planetingres.org (Ingres and related product discussion forum)

    I think the feature has been migrated from vectorwise. Check out


    https://docs.actian.com/vector/6.0/index.html#page/SQLLang/CREATE_FUNCTION.htm

    Paul

    On Tue, 15 Jun 2021, 7:19 pm Martin Bowes, <martin.bowes@ndph.ox.ac.uk>
    wrote:

    Hi Paul,



    I created the function in iidbdb. And you can’t enable x100 on iidbdb.



    Also what on earth has x100 to do with create function anyway?



    Marty



    *From:* Paul White <paul.white@shift7solutions.com.au>
    *Sent:* 15 June 2021 10:10
    *To:* Martin Bowes <martin.bowes@ndph.ox.ac.uk>; info-ingres@lists.planetingres.org
    *Subject:* Re: [Info-ingres] drop function error



    try

    alterdb -enable_x100 martydb

    If the database was created with -no_x100 then the drop statement fails.







    On 15/06/2021 6:20 pm, Martin Bowes wrote:

    Hi All,



    In 11.2 we can now do CREATE FUNCTION!



    So as an unprivileged user I created a function in iidbdb, it worked, and then I tried to drop it…



    drop function helloworld\g

    Executing . . .



    E_US253F X100 statements are disabled for this database or session.

    (Tue Jun 15 09:12:46 2021)



    So I logged in as ingres, connected to iidbdb and did:

    drop function "martinb".helloworld\g

    Executing . . .



    Error message corresponding to 328736 (50420) not found in

    INGRES error file

    ()



    Any ideas on how to drop this bloody thing?



    Martin Bowes



    _______________________________________________

    Info-ingres mailing list

    Info-ingres@lists.planetingres.org

    https://lists.planetingres.org/mailman/listinfo/info-ingres

    _______________________________________________
    Info-ingres mailing list
    Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres


    <div dir="auto">I think the feature has been migrated from vectorwise.  Check out  <div dir="auto"><br></div><div dir="auto"> <a href="https://docs.actian.com/vector/6.0/index.html#page/SQLLang/CREATE_FUNCTION.htm">https://docs.actian.com/vector/6.0/
    index.html#page/SQLLang/CREATE_FUNCTION.htm</a></div><div dir="auto"><br></div><div dir="auto">Paul</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, 15 Jun 2021, 7:19 pm Martin Bowes, &lt;<a href="mailto:martin.bowes@ndph.
    ox.ac.uk">martin.bowes@ndph.ox.ac.uk</a>&gt; wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">





    <div lang="EN-GB" link="#0563C1" vlink="#954F72">
    <div class="m_-4079250221995666326WordSection1">
    <p class="MsoNormal"><span style="color:#1f497d">Hi Paul,<u></u><u></u></span></p>
    <p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
    <p class="MsoNormal"><span style="color:#1f497d">I created the function in iidbdb. And you can’t enable x100 on iidbdb.<u></u><u></u></span></p>
    <p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
    <p class="MsoNormal"><span style="color:#1f497d">Also what on earth has x100 to do with create function anyway?<u></u><u></u></span></p>
    <p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
    <p class="MsoNormal"><span style="color:#1f497d">Marty<u></u><u></u></span></p> <p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p> <div>
    <div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
    <p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> Paul White &lt;<a href="mailto:paul.white@shift7solutions.com.au" target="_blank" rel="noreferrer">paul.white@shift7solutions.com.au</a>&gt;

    <b>Sent:</b> 15 June 2021 10:10<br>
    <b>To:</b> Martin Bowes &lt;<a href="mailto:martin.bowes@ndph.ox.ac.uk" target="_blank" rel="noreferrer">martin.bowes@ndph.ox.ac.uk</a>&gt;; <a href="mailto:info-ingres@lists.planetingres.org" target="_blank" rel="noreferrer">info-ingres@lists.
    planetingres.org</a><br>
    <b>Subject:</b> Re: [Info-ingres] drop function error<u></u><u></u></span></p> </div>
    </div>
    <p class="MsoNormal"><u></u> <u></u></p>
    <p>try <span style="font-size:12.0pt"><u></u><u></u></span></p>
    <p>alterdb -enable_x100 martydb <u></u><u></u></p>
    <p>If the database was created with -no_x100 then the drop statement fails.<u></u><u></u></p>
    <p class="MsoNormal"><u></u> <u></u></p>
    <p><u></u> <u></u></p>
    <p><u></u> <u></u></p>
    <p class="MsoNormal">On 15/06/2021 6:20 pm, Martin Bowes wrote:<br>

    <u></u><u></u></p>
    <blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
    <p class="MsoNormal">Hi All,<u></u><u></u></p>
    <p class="MsoNormal"> <u></u><u></u></p>
    <p class="MsoNormal">In 11.2 we can now do CREATE FUNCTION!<u></u><u></u></p> <p class="MsoNormal"> <u></u><u></u></p>
    <p class="MsoNormal">So as an unprivileged user I created a function in iidbdb, it worked, and then I tried to drop it…<u></u><u></u></p>
    <p class="MsoNormal"> <u></u><u></u></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">drop function helloworld\g</span><u></u><u></u></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">Executing . . .</span><u></u><u></u></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif"> </span><u></u><u></u></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">E_US253F X100 statements are disabled for this database or session.</span><u></u><u></u></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">    (Tue Jun 15 09:12:46 2021)</span><u></u><u></u></p>
    <p class="MsoNormal"> <u></u><u></u></p>
    <p class="MsoNormal">So I logged in as ingres, connected to iidbdb and did:<u></u><u></u></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">drop function &quot;martinb&quot;.helloworld\g</span><u></u><u></u></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">Executing . . .</span><u></u><u></u></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif"> </span><u></u><u></u></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">Error message corresponding to 328736 (50420)               not found in</span><u></u><u></u></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">    INGRES error file</span><u></u><u></u></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">    ()</span><u></u><u></u></p>
    <p class="MsoNormal"> <u></u><u></u></p>
    <p class="MsoNormal">Any ideas on how to drop this bloody thing?<u></u><u></u></p>
    <p class="MsoNormal"> <u></u><u></u></p>
    <p class="MsoNormal">Martin Bowes<u></u><u></u></p>
    <p class="MsoNormal"><span style="font-size:12.0pt;font-family:&quot;Times New Roman&quot;,serif"><br>

    <u></u><u></u></span></p> <pre>_______________________________________________<u></u><u></u></pre> <pre>Info-ingres mailing list<u></u><u></u></pre>
    <pre><a href="mailto:Info-ingres@lists.planetingres.org" target="_blank" rel="noreferrer">Info-ingres@lists.planetingres.org</a><u></u><u></u></pre>
    <pre><a href="https://lists.planetingres.org/mailman/listinfo/info-ingres" target="_blank" rel="noreferrer">https://lists.planetingres.org/mailman/listinfo/info-ingres</a><u></u><u></u></pre>
    </blockquote>
    </div>
    </div>

    _______________________________________________<br>
    Info-ingres mailing list<br>
    <a href="mailto:Info-ingres@lists.planetingres.org" target="_blank" rel="noreferrer">Info-ingres@lists.planetingres.org</a><br>
    <a href="https://lists.planetingres.org/mailman/listinfo/info-ingres" rel="noreferrer noreferrer" target="_blank">https://lists.planetingres.org/mailman/listinfo/info-ingres</a><br>
    </blockquote></div>

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin Bowes@21:1/5 to All on Tue Jun 15 09:19:04 2021
    To: info-ingres@lists.planetingres.org (info-ingres@lists.planetingres.org)

    Hi Paul,

    I created the function in iidbdb. And you can't enable x100 on iidbdb.

    Also what on earth has x100 to do with create function anyway?

    Marty

    From: Paul White <paul.white@shift7solutions.com.au>
    Sent: 15 June 2021 10:10
    To: Martin Bowes <martin.bowes@ndph.ox.ac.uk>; info-ingres@lists.planetingres.org
    Subject: Re: [Info-ingres] drop function error


    try

    alterdb -enable_x100 martydb

    If the database was created with -no_x100 then the drop statement fails.





    On 15/06/2021 6:20 pm, Martin Bowes wrote:

    Hi All,

    In 11.2 we can now do CREATE FUNCTION!

    So as an unprivileged user I created a function in iidbdb, it worked, and then I tried to drop it...

    drop function helloworld\g
    Executing . . .

    E_US253F X100 statements are disabled for this database or session.
    (Tue Jun 15 09:12:46 2021)

    So I logged in as ingres, connected to iidbdb and did:
    drop function "martinb".helloworld\g
    Executing . . .

    Error message corresponding to 328736 (50420) not found in
    INGRES error file
    ()

    Any ideas on how to drop this bloody thing?

    Martin Bowes



    _______________________________________________

    Info-ingres mailing list

    Info-ingres@lists.planetingres.org<mailto:Info-ingres@lists.planetingres.org>

    https://lists.planetingres.org/mailman/listinfo/info-ingres

    <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
    <meta name="Generator" content="Microsoft Word 15 (filtered medium)"> <style><!--
    /* Font Definitions */
    @font-face
    {font-family:"Cambria Math";
    panose-1:2 4 5 3 5 4 6 3 2 4;}
    @font-face
    {font-family:Calibri;
    panose-1:2 15 5 2 2 2 4 3 2 4;}
    @font-face
    {font-family:Consolas;
    panose-1:2 11 6 9 2 2 4 3 2 4;}
    @font-face
    {font-family:"Lucida Console";
    panose-1:2 11 6 9 4 5 4 2 2 4;}
    /* Style Definitions */
    p.MsoNormal, li.MsoNormal, div.MsoNormal
    {margin:0cm;
    margin-bottom:.0001pt;
    font-size:11.0pt;
    font-family:"Calibri",sans-serif;
    mso-fareast-language:EN-US;}
    a:link, span.MsoHyperlink
    {mso-style-priority:99;
    color:#0563C1;
    text-decoration:underline;}
    a:visited, span.MsoHyperlinkFollowed
    {mso-style-priority:99;
    color:#954F72;
    text-decoration:underline;}
    p
    {mso-style-priority:99;
    mso-margin-top-alt:auto;
    margin-right:0cm;
    mso-margin-bottom-alt:auto;
    margin-left:0cm;
    font-size:11.0pt;
    font-family:"Calibri",sans-serif;
    mso-fareast-language:EN-US;}
    pre
    {mso-style-priority:99;
    mso-style-link:"HTML Preformatted Char";
    margin:0cm;
    margin-bottom:.0001pt;
    font-size:10.0pt;
    font-family:"Courier New";
    mso-fareast-language:EN-GB;}
    p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
    {mso-style-priority:34;
    margin-top:0cm;
    margin-right:0cm;
    margin-bottom:0cm;
    margin-left:36.0pt;
    margin-bottom:.0001pt;
    font-size:11.0pt;
    font-family:"Calibri",sans-serif;
    mso-fareast-language:EN-US;}
    span.HTMLPreformattedChar
    {mso-style-name:"HTML Preformatted Char";
    mso-style-priority:99;
    mso-style-link:"HTML Preformatted";
    font-family:Consolas;
    mso-fareast-language:EN-US;}
    p.msonormal0, li.msonormal0, div.msonormal0
    {mso-style-name:msonormal;
    mso-style-priority:99;
    mso-margin-top-alt:auto;
    margin-right:0cm;
    mso-margin-bottom-alt:auto;
    margin-left:0cm;
    font-size:12.0pt;
    font-family:"Times New Roman",serif;
    mso-fareast-language:EN-GB;}
    span.EmailStyle22
    {mso-style-type:personal;
    font-family:"Calibri",sans-serif;
    color:windowtext;}
    span.EmailStyle23
    {mso-style-type:personal-reply;
    font-family:"Calibri",sans-serif;
    color:#1F497D;}
    .MsoChpDefault
    {mso-style-type:export-only;
    font-size:10.0pt;}
    @page WordSection1
    {size:612.0pt 792.0pt;
    margin:72.0pt 72.0pt 72.0pt 72.0pt;}
    div.WordSection1
    {page:WordSection1;}
    </style><!--[if gte mso 9]><xml>
    <o:shapedefaults v:ext="edit" spidmax="1026" />
    </xml><![endif]--><!--[if gte mso 9]><xml>
    <o:shapelayout v:ext="edit">
    <o:idmap v:ext="edit" data="1" />
    </o:shapelayout></xml><![endif]-->
    </head>
    <body lang="EN-GB" link="#0563C1" vlink="#954F72">
    <div class="WordSection1">
    <p class="MsoNormal"><span style="color:#1F497D">Hi Paul,<o:p></o:p></span></p> <p class="MsoNormal"><span style="color:#1F497D"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span style="color:#1F497D">I created the function in iidbdb. And you can&#8217;t enable x100 on iidbdb.<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="color:#1F497D"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span style="color:#1F497D">Also what on earth has x100 to do with create function anyway?<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="color:#1F497D"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span style="color:#1F497D">Marty<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="color:#1F497D"><o:p>&nbsp;</o:p></span></p> <div>
    <div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
    <p class="MsoNormal"><b><span lang="EN-US" style="mso-fareast-language:EN-GB">From:</span></b><span lang="EN-US" style="mso-fareast-language:EN-GB"> Paul White &lt;paul.white@shift7solutions.com.au&gt;

    <b>Sent:</b> 15 June 2021 10:10<br>
    <b>To:</b> Martin Bowes &lt;martin.bowes@ndph.ox.ac.uk&gt;; info-ingres@lists.planetingres.org<br>
    <b>Subject:</b> Re: [Info-ingres] drop function error<o:p></o:p></span></p> </div>
    </div>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p>try <span style="font-size:12.0pt;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
    <p>alterdb -enable_x100 martydb <o:p></o:p></p>
    <p>If the database was created with -no_x100 then the drop statement fails.<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p><o:p>&nbsp;</o:p></p>
    <p><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">On 15/06/2021 6:20 pm, Martin Bowes wrote:<br>

    <o:p></o:p></p>
    <blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
    <p class="MsoNormal">Hi All,<o:p></o:p></p>
    <p class="MsoNormal">&nbsp;<o:p></o:p></p>
    <p class="MsoNormal">In 11.2 we can now do CREATE FUNCTION!<o:p></o:p></p>
    <p class="MsoNormal">&nbsp;<o:p></o:p></p>
    <p class="MsoNormal">So as an unprivileged user I created a function in iidbdb, it worked, and then I tried to drop it&#8230;<o:p></o:p></p>
    <p class="MsoNormal">&nbsp;<o:p></o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">drop function helloworld\g</span><o:p></o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">Executing . . .</span><o:p></o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">&nbsp;</span><o:p></o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">E_US253F X100 statements are disabled for this database or session.</span><o:p></o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">&nbsp;&nbsp;&nbsp; (Tue Jun 15 09:12:46 2021)</span><o:p></o:p></p>
    <p class="MsoNormal">&nbsp;<o:p></o:p></p>
    <p class="MsoNormal">So I logged in as ingres, connected to iidbdb and did:<o:p></o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">drop function &quot;martinb&quot;.helloworld\g</span><o:p></o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">Executing . . .</span><o:p></o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">&nbsp;</span><o:p></o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">Error message corresponding to 328736 (50420)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    not found in</span><o:p></o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">&nbsp;&nbsp;&nbsp; INGRES error file</span><o:p></o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;,serif">&nbsp;&nbsp;&nbsp; ()</span><o:p></o:p></p>
    <p class="MsoNormal">&nbsp;<o:p></o:p></p>
    <p class="MsoNormal">Any ideas on how to drop this bloody thing?<o:p></o:p></p> <p class="MsoNormal">&nbsp;<o:p></o:p></p>
    <p class="MsoNormal">Martin Bowes<o:p></o:p></p>
    <p class="MsoNormal"><span style="font-size:12.0pt;font-family:&quot;Times New Roman&quot;,serif;mso-fareast-language:EN-GB"><br>

    <o:p></o:p></span></p> <pre>_______________________________________________<o:p></o:p></pre> <pre>Info-ingres mailing list<o:p></o:p></pre>
    <pre><a href="mailto:Info-ingres@lists.planetingres.org">Info-ingres@lists.planetingres.org</a><o:p></o:p></pre>
    <pre><a href="https://lists.planetingres.org/mailman/listinfo/info-ingres">https://lists.planetingres.org/mailman/listinfo/info-ingres</a><o:p></o:p></pre>
    </blockquote>
    </div>
    </body>
    </html>

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)