Skip to main content
Question

Adding design table query is not working

  • August 24, 2020
  • 3 replies
  • 14 views

HyeontaeJu
Forum|alt.badge.img+2

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;

3 replies

mosheg
Forum|alt.badge.img+2
  • Participating Frequently
  • August 24, 2020

Please try:
SELECT * FROM vs_design_tables;


Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • August 24, 2020

@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)

HyeontaeJu
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • August 25, 2020

@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