On Mar 6, 2011, at 9:29 AM, Guillaume Lelarge wrote:
> Le 14/02/2011 22:28, Guillaume Lelarge a écrit :
>> 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
pgadmingenerated 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 :) ).
>>
>
> Seems I was totally wrong. pgAdmin supports default values for columns
> in views since quite some time (at least 1.12). It doesn't use the ALTER
> VIEW statement, but the ALTER TABLE one. I don't think we really need to
> change this right now. It works and that's good enough for me.
>
> Can you check your release and see if you have the ALTER TABLE
> statement? it should be after the ALTER TABLE that sets the owner.
I can confirm that is indeed the case- thanks for pointing that out. The column defaults appear between the ACLs and
rules.
Cheers,
M