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