[Info-ingres] drop function error

[Paul White]

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 at 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 at shift7solutions.com.au>
> *Sent:* 15 June 2021 10:10
> *To:* Martin Bowes <martin.bowes at ndph.ox.ac.uk>;
> info-ingres at 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 at lists.planetingres.org
>
> https://lists.planetingres.org/mailman/listinfo/info-ingres
>
> _______________________________________________
> Info-ingres mailing list
> Info-ingres at lists.planetingres.org
> https://lists.planetingres.org/mailman/listinfo/info-ingres
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20210615/703bfd6f/attachment.html>