I have a long script, that loads several temp tables (so no commit happens here) using COPY, then performs joins and so on. In the end of the script I have a COMMIT statement. I want to implement logic, like: IF no_errors_happened() THEN COMMIT, else ROLLBACK; Is it possible somehow in Vertica 5.1? ...

vsql and vertica are the same version. But I do copy over the network. So, it seems that the only solution for now is to use direct copy on vertica instance...

Hello! We have vertica 5.1 installed and use vsql v5.1.0-0. It works perfectly while loading big files like this: cat /foo_bar.csv | vsql ... -c "COPY .... FROM LOCAL STDIN" , but when we issue the similar command vsql ... -c "COPY .... FROM LOCAL '/foo_bar.csv'" , it hangs when size of file is over...