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
Le 14/02/2011 13:05, Maximilian Tyrtania a écrit :
> Just found this in the archives:
>
>> Andy Colson writes:
>>> Having a little problem with my large objects. In 8.4 the db owner was
>>> 'andy', but my web connected as payuser (which had appropriate permissions).
>>
>>> The backup/restore to
Just found this in the archives:
> Andy Colson writes:
> > Having a little problem with my large objects. In 8.4 the db owner was
> > 'andy', but my web connected as payuser (which had appropriate permissions).
>
> > The backup/restore to pg9 made all the large objects owned by 'andy',
> > an
