[Info-ingres] drop function error

[Martin Bowes]

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<mailto: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/0a62f640/attachment-0001.html>