[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-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 по дате отправления: