[pgAdmin III] #308: view column defaults not displayed

Поиск
Список
Период
Сортировка
От pgAdmin Trac
Тема [pgAdmin III] #308: view column defaults not displayed
Дата
Msg-id 045.423f47e958bf6b71fdbf7c1c5f16c394@code.pgadmin.org
обсуждение исходный текст
Ответы Re: [pgAdmin III] #308: view column defaults not displayed  ("pgAdmin Trac" <trac@code.pgadmin.org>)
Список 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

В списке pgadmin-hackers по дате отправления:

Предыдущее
От: Nikhil S
Дата:
Сообщение: Re: pgAdmin III: the debugger does not pre-populate default values for arguments
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: phase 2 of wxWidgets 2.9 build