Skip site navigation (1) Skip section navigation (2)

[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 (view raw or flat)
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

pgadmin-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group