You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@madlib.apache.org by GitBox <gi...@apache.org> on 2021/03/04 07:49:45 UTC

[GitHub] [madlib] orhankislal commented on pull request #554: DL: Check if the owner of the object table is a superuser

orhankislal commented on pull request #554:
URL: https://github.com/apache/madlib/pull/554#issuecomment-790402878


   > It look like it created the `custom_function_table` in the madlib schema even though I was working in the public schema. So the `DROP TABLE IF EXISTS custom_function_table` did not work. If I change it to `DROP TABLE IF EXISTS madlib.custom_function_table` then it does work.
   > 
   > Is that the intended behavior?
   
   Yes, this is the intended behavior. The custom_function_table is created in the madlib schema, it doesn't matter what your search_path looks like. Your code tries to drop the non-existent `public.custom_function_table` and then tries to load the `squared_error` function a second time on the `madlib.custom_function_table` table which fails as expected. 
   Since you are an admin, you are allowed to drop tables from the `madlib` schema.
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org