From: Tarik Dolovac <tarik.dolovac.sa@gmail.com>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: pgsql-docs@postgresql.org <pgsql-docs@postgresql.org>
Subject: Re: Syntax for changing owner on sequence is not correct
Date: Thu, 24 Aug 2017 20:25:13 +0200
Message-ID: <FCCE3692-5A3E-4C25-9325-7FBD3FF42811@gmail.com> (raw)
In-Reply-To: <CAKFQuwYrRX6cuaDHKRs6rVJo5YR9hiVKKaBzKdDq9qiruhB8yQ@mail.gmail.com>
References: <20170809093549.8423.81493@wrigleys.postgresql.org>
<c2479546-38d4-f7ac-5667-a296b8c8fce2@2ndquadrant.com>
<CAKFQuwYrRX6cuaDHKRs6rVJo5YR9hiVKKaBzKdDq9qiruhB8yQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
I am just telling you that in your officiall documentation i didn't find that command. I founded oj stack owerflow and when i changed command I succesfully changed owner. Also one more hit: documentation will be much better with examples. I am DBA for a 7 years on ms sql and oracle and they have examples which can make life more easily if you are starting with some new tehnologies like postgres.
Kind regards,
Tarik Dolovac
Sent from my iPhone
> On 10 Aug 2017, at 16:04, David G. Johnston <david.g.johnston@gmail.com> wrote:
>
>> On Thu, Aug 10, 2017 at 5:37 AM, Peter Eisentraut <peter.eisentraut@2ndquadrant.com> wrote:
>
>> On 8/9/17 05:35, tarik.dolovac.sa@gmail.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'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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: tarik.dolovac.sa@gmail.com, david.g.johnston@gmail.com, peter.eisentraut@2ndquadrant.com
Subject: Re: Syntax for changing owner on sequence is not correct
In-Reply-To: <FCCE3692-5A3E-4C25-9325-7FBD3FF42811@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox