dpage
commented
13 years ago Comment migrated from Redmine: https://redmine.postgresql.org/issues/552#note-1 Originally created by Guillaume Lelarge at 2011-03-06 14:29:47 UTC.
Redmine ticket header update:
| Name | Old Value | New Value |
|---|---|---|
| Status changed | New | Resolved |
| Resolution changed | works for me |
Issue migrated from Redmine: https://redmine.postgresql.org/issues/552 Originally created by Anonymous at 2011-02-14 16:51:02 UTC.
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;