Re: Syntax for changing owner on sequence is not correct

On Thu, Aug 10, 2017 at 5:37 AM, Peter Eisentraut <
peter(dot)eisentraut(at)2ndquadrant(dot)com> wrote:

> On 8/9/17 05:35, tarik(dot)dolovac(dot)sa(at)gmail(dot)com wrote:
> > The following documentation comment has been logged on the website:
> >
> > Page: https://www.postgresql.org/docs/8.4/static/sql-altersequence.html
> > Description:
> >
> > Per documentation owner changing should use
> > owner to
> > this syntax doesn&#39;t work al 9.5 version
> > owned by
> > is working please correct because I spent over 3 hour until I figure out
> > what is the problem
>
> Are you saying that ALTER SEQUENCE ... OWNER TO doesn't work? It
> appears to work for everyone else.
>

​Sequences can have two owners - a role and, ​optionally, a table.column.

The name following "OWNED BY" is a table.column (NONE to clear).
The name following "OWNER TO" is a role (mandatory).

David J.