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

From: "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org>
To:
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgAdmin III] #308: view column defaults not displayed
Date: 2011-02-14 16:51:03
Message-ID: 045.423f47e958bf6b71fdbf7c1c5f16c394@code.pgadmin.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2011-02-15 03:50:03 Re: phase 2 of wxWidgets 2.9 build
Previous Message Nikhil S 2011-02-14 12:53:09 Re: pgAdmin III: the debugger does not pre-populate default values for arguments