Обсуждение: [pgAdmin III] #308: view column defaults not displayed

#308: view column defaults not displayed
---------------------+------------------------------------------------------
 Reporter:  A.M.     |       Owner:  dpage
     Type:  feature  |      Status:  new  
 Priority:  minor    |   Milestone:       
Component:  pgadmin  |     Version:  1.12 
 Keywords:  views    |    Platform:       
---------------------+------------------------------------------------------
 I am using ALTER VIEW x ALTER COLUMN  y SET DEFAULT defaultclause, but the
 defaults do not seem to appear in the pgadmin generated SQL for the view.
 Is this a deliberate omission? psql does display view column defaults:

 test=# CREATE VIEW test.trash AS SELECT 1 AS a;
 CREATE VIEW
 test=# ALTER VIEW test.trash ALTER COLUMN a SET DEFAULT 5;
 ALTER VIEW
 test=# \d+ test.trash
                   View "test.trash"
  Column |  Type   | Modifiers | Storage | Description
 --------+---------+-----------+---------+-------------
  a      | integer | default 5 | plain   |
 View definition:
  SELECT 1 AS a;

--
Ticket URL: <http://code.pgadmin.org/trac/ticket/308>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III

#308: view column defaults not displayed
---------------------------+------------------------------------------------
  Reporter:  A.M.          |       Owner:  dpage 
      Type:  feature       |      Status:  closed
  Priority:  minor         |   Milestone:        
 Component:  pgadmin       |     Version:  1.12  
Resolution:  works for me  |    Keywords:  views 
  Platform:                |  
---------------------------+------------------------------------------------
Changes (by gleu):

  * status:  new => closed
  * resolution:  => works for me


--
Ticket URL: <http://code.pgadmin.org/trac/ticket/308#comment:1>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III