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
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 di
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 f
Hello,
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:
test=# CREATE VIEW test.trash AS SELECT 1 AS a;
CREATE VIEW
test=# A
