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: 4D599E73.4020101@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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 :) ).

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

In response to

Responses

Browse pgadmin-support by date

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