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

Re: view column defaults not displayed

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: view column defaults not displayed
Date: 2011-02-14 21:28:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
Le 14/02/2011 21:51, A.M. a écrit :
> [...]
> 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:

Mainly because it was forgotten. I checked, it's available since 8.4.
Should be an easy patch (once someone found the time to work on it :) ).


In response to


pgadmin-support by date

Next:From: Maximilian TyrtaniaDate: 2011-02-15 14:16:15
Subject: Re: large objects permission issue
Previous:From: A.M.Date: 2011-02-14 20:51:24
Subject: view column defaults not displayed

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