Re: alter + preserving dependencies

Dimitri Fontaine wrote:
> Le 7 mai 08 à 07:52, Tom Lane a écrit :
>
>> Dimitri Fontaine <dim@hi-media.com> writes:
>>> Could we consider ALTER VIEW ALTER COLUMN ... SET DEFAULT ...;?
>>
>> We could if we hadn't already done it five or so years ago.
>> Or am I missing what you need here?
>
> My 8.3.1 installation psql \h only gives me:
> Syntax:
> ALTER VIEW name RENAME TO newname

Ah, you use ALTER TABLE:

ALTER TABLE my_view ALTER COLUMN view_column DEFAULT expr;

--   Richard Huxton  Archonet Ltd