[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
Список
Дерево обсуждения
[pgAdmin III] #308: view column defaults not displayed "pgAdmin Trac" <trac@code.pgadmin.org>
Re: [pgAdmin III] #308: view column defaults not displayed "pgAdmin Trac" <trac@code.pgadmin.org>
#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:
pgAdmin III
pgAdmin III
В списке pgadmin-hackers по дате отправления
От: Nikhil S
Дата: