You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello, I have ran into issue with dropping cstore table and then rollbacking the transaction.
Rollback leaves the table in an inconsistent state as the table definition still exists (which is correct), but cstore data files are deleted and not rolled back with the rest of the transaction.
Steps to reproduce:
-- create empty cstore table
create foreign table cstore_drop_test()
server cstore_server;
-- query without errorsselect*from cstore_drop_test;
-- drop cstore table and then rollback
DO language plpgsql
$$
DECLARE
BEGIN
drop foreign table cstore_drop_test;
rollback;
END
$$;
-- query fails on 'could not open file "xxx.footer" for reading'select*from cstore_drop_test;
The text was updated successfully, but these errors were encountered:
Hello, I have ran into issue with dropping cstore table and then rollbacking the transaction.
Rollback leaves the table in an inconsistent state as the table definition still exists (which is correct), but cstore data files are deleted and not rolled back with the rest of the transaction.
Steps to reproduce:
The text was updated successfully, but these errors were encountered: