Search found 8 matches
- Thu Aug 01, 2013 12:16 pm
- Forum: Vertica Database Development
- Topic: Strange behavior on SELECT+DROP
- Replies: 1
- Views: 5542
Strange behavior on SELECT+DROP
When I execute a SELECT to my TestTable, output is as expected, vsql -dX -c "SELECT * FROM TestTable;" but when I introduce something like: vsql -dX -c "SELECT * FROM TestTable; DROP TABLE IF EXISTS TestTable;" Does not show anything and does not throw an error neither Does anybody know the cause?
- Wed Jul 31, 2013 5:32 pm
- Forum: Vertica Database Development
- Topic: vsql command + SEARCH_PATH
- Replies: 5
- Views: 13150
Re: vsql command + SEARCH_PATH
I solve it now I upgraded, but anyway I think it would really be great if ALTERing USER did not need a connection restart. It's bad for long and compelx scripts, for instance, where you need to reopen a connection everytime you change ! Any solution for changing it permanently dynamically and easily?
- Mon Jul 29, 2013 2:12 pm
- Forum: Vertica Database Development
- Topic: vsql command + SEARCH_PATH
- Replies: 5
- Views: 13150
Re: vsql command + SEARCH_PATH
You're right. My fault. 6.0.1...
- Mon Jul 29, 2013 11:41 am
- Forum: Vertica Database Development
- Topic: vsql command + SEARCH_PATH
- Replies: 5
- Views: 13150
Re: vsql command + SEARCH_PATH
Sorry it is not working for me. May you help me? VMart=> \du List of users User name | Is Superuser -----------+-------------- dbadmin | t (1 row) VMart=> ALTER USER dbadmin SEARCH_PATH temp; ERROR 4856: Syntax error at or near "SEARCH_PATH" at character 20 LINE 1: ALTER USER dbadmin SEARCH_PATH tem...
- Mon Jul 29, 2013 10:54 am
- Forum: Vertica Database Development
- Topic: Non buffered results
- Replies: 2
- Views: 5876
Re: Non buffered results
Thanks!!
- Fri Jul 26, 2013 4:34 pm
- Forum: Vertica Database Development
- Topic: Non buffered results
- Replies: 2
- Views: 5876
Non buffered results
Can I deactivate the option for buffering results?
I mean the pause and ----- more ----- thing from the console
Thank you!
I mean the pause and ----- more ----- thing from the console
Thank you!
- Fri Jul 26, 2013 4:29 pm
- Forum: Vertica SQL Functions
- Topic: GROUP_CONCAT()
- Replies: 1
- Views: 12420
GROUP_CONCAT()
Is there any easy way to emulate MySQL's and others GROUP_CONCAT (Concat as an aggregation function) without needing to create a procedure in Vertica? Thanks!