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

view column defaults not displayed

From: "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: view column defaults not displayed
Date: 2011-02-14 20:51:24
Message-ID: 8C97310B-1FBA-48B4-BC4C-CEB06B4700CF@themactionfaction.com (view raw or flat)
Thread:
Lists: pgadmin-support
Hello,

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;

Cheers,
M

Responses

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2011-02-14 21:28:19
Subject: Re: view column defaults not displayed
Previous:From: Guillaume LelargeDate: 2011-02-14 12:30:31
Subject: Re: large objects permission issue

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