From: | "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: view column defaults not displayed |
Date: | 2011-03-06 21:38:40 |
Message-ID: | 89DEA870-F486-48D8-B2D2-381FB5CF426C@themactionfaction.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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 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 :) ).
>>
>
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Qiqi YU | 2011-03-07 07:19:07 | where are the query output tuples stored |
Previous Message | Guillaume Lelarge | 2011-03-06 15:44:38 | Re: Backup a table |