The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Adding design table query is not working

I'm trying to work this Query to make design table
SELECT DESIGNER_ADD_DESIGN_TABLES('juhyeontae_1', '[schema.tableName]');
and result is 1
But, when i was trying to process to check the adding table but, design table is not made
SELECT * FROM design_tables;
0
Best Answers
-
Jim_Knicely - Select Field - Administrator
@HyeontaeJu - Attached is an example deck showing the set up how to run the DBD functions manually.
And here is another example:
dbadmin=> \c - ma_dbd You are now connected as user "ma_dbd". dbadmin=> \dt ma List of tables Schema | Name | Kind | Owner | Comment --------+------+-------+--------+--------- public | ma | table | ma_dbd | (1 row) dbadmin=> SELECT designer_create_design('ma2'); designer_create_design ------------------------ 0 (1 row) dbadmin=> SELECT designer_add_design_tables('ma2', 'public.ma', TRUE); designer_add_design_tables ---------------------------- 1 (1 row) dbadmin=> SELECT * FROM design_tables; design_name | design_table_id | table_schema | table_id | table_name -------------+-----------------+--------------+-------------------+------------ ma2 | 1 | public | 45035996273855326 | ma (1 row) dbadmin=> SELECT designer_add_design_tables('ma2', 'public.zero', TRUE); WARNING 5390: User has insufficient privileges on table zero HINT: User must be owner of the design table designer_add_design_tables ---------------------------- 0 (1 row) dbadmin=> SELECT * FROM design_tables; design_name | design_table_id | table_schema | table_id | table_name -------------+-----------------+--------------+-------------------+------------ ma2 | 1 | public | 45035996273855326 | ma (1 row)
1
Answers
@Jim_Knicely Oh.. Thank you very much sincerly..
My Question is solved.. Thanks your answer
I wanna more thankful phrase to you but, my English skill is rookie.. haha..
anyway, Thank very much