[pgAdmin III] #308: view column defaults not displayed - Mailing list pgadmin-hackers

#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