[Info-ingres] drop function error

Paul White paul.white at shift7solutions.com.au
Tue Jun 15 09:10:04 UTC 2021


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20210615/9bde428c/attachment.html>


More information about the Info-ingres mailing list