Why it is not allowed to change owner of temp table

scherepanovscherepanov ✭✭
edited July 22 in General Discussion

Hi,

User left... user account got deleted... his tables ownership got automatically transferred to global heir account.
I am trying to set a correct owner of those tables. For temp tables I am getting an error:

[Code: 2368, SQL State: 0A000] [Vertica]VJDBC ROLLBACK: Cannot change owner of temporary table

For me it sounds like an unreasonable limitation...

Can you file ticket with development, asking to reconsider this limitation and remove it. Anyway, Vertica automatically changed ownership of temp tables when owner account got deleted. I do not see a reason why superuser cannot change it too.

Thank you
Sergey

Best Answer

Answers

  • SruthiASruthiA Administrator

    I have filed a JIRA VER-95729

  • SruthiASruthiA Administrator

    this issue is being fixed in major version(24.4). do you need backport for it?

  • scherepanovscherepanov ✭✭
    edited July 31

    Thank you!
    No need to backport, it is a very minor issue.

  • SruthiASruthiA Administrator

    ok.. so it will be fixed in 24.4. please upgrade when it is released

  • Great!
    Thanks!

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file