Re: alter + preserving dependencies

Dimitri Fontaine wrote:
> Le 7 mai 08 =E0 07:52, Tom Lane a =E9crit :
>=20
>> Dimitri Fontaine <dim@[EMAIL PROTECTED]
> 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?
>=20
> 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;

--=20
   Richard Huxton
   Archonet Ltd

--=20
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers