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
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 |