Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dmS3y-0001SP-Mc for pgsql-docs@arkaria.postgresql.org; Mon, 28 Aug 2017 21:59:18 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dmS3y-0000TB-8T for pgsql-docs@arkaria.postgresql.org; Mon, 28 Aug 2017 21:59:18 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dkwoi-0004BQ-Mg for pgsql-docs@postgresql.org; Thu, 24 Aug 2017 18:25:20 +0000 Received: from mail-wm0-x241.google.com ([2a00:1450:400c:c09::241]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dkwof-0003Ne-P2 for pgsql-docs@postgresql.org; Thu, 24 Aug 2017 18:25:19 +0000 Received: by mail-wm0-x241.google.com with SMTP id i76so273525wme.1 for ; Thu, 24 Aug 2017 11:25:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=+MdZpiuUOelP4k9XWXFvdGShkXdm7t3bXAif1EGJ7aA=; b=rtAmRzNqJuP6Udd/Kk91T94s2RgO3DGjhyTa0JQ7/f2Cy6XzRwTYPmxHyROTgNmub2 chqUKheE8FbBd/Kk5IIRuzvLl8q/Zexb5SsgIXZpZmXThV6fQUjBiDjuKGve13a/2Gdf YNY+Dc9Gmn/UDrP7Viwku9N9MRhJw95OMkb81XexDJr5TvJxywQ90GfJCfNrC6mm/oau 2dsp/Nl8YEdxUgIDr4y9vOd39qFJzTt4JnjbwBx262EiREbEoVfian93odwvulTSnj28 ztiesmGBVnlBBelpQRISTGitWZPyjxhxMO/3AgOsi5ughLtImM3fNpXoQ6CDBBSxCc+v TxVQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=+MdZpiuUOelP4k9XWXFvdGShkXdm7t3bXAif1EGJ7aA=; b=DQvfTvKW/m/K12Ce9kxjDPF8LtMXs8zZTjWy+IpJi1hogQx2LsKpNIbKwEIx0weiNc 6joQPFuTx12KYaPgrIzYghDW9E7ljZFe6KYQrRPNSU8FWWkwltqlrVe35tXTxvGKlwFq gWlvaJyQNPB8kLJbuqP6iHgvNFr3wjnwp+GPzYEe+qEBeTSRFTZN5VNREvEyppmuEIIJ WUIy23xOTHkE4juz4UP6q9c2Ucg5fpv2mS5zgJkPvyplqekiuk2R0mgIgqjI7LAdkhwk u4+Smh8w0KeqRZhHsJ59a3E6UxqbvgjODqgEHThrwd8yiACl0iPaenb0V23hFJoPE1AH Eh3A== X-Gm-Message-State: AHYfb5h7ekuPacfySEqbJI4cNX1Pc+cogYzSlAVzjVF2zM0d3R6utFMP aTUDsVSmK4tnxFWnt80= X-Received: by 10.28.37.2 with SMTP id l2mr4770781wml.112.1503599115042; Thu, 24 Aug 2017 11:25:15 -0700 (PDT) Received: from [192.168.0.18] ([217.197.140.17]) by smtp.gmail.com with ESMTPSA id v35sm1382113wrc.73.2017.08.24.11.25.13 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 24 Aug 2017 11:25:14 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-4BF28E20-A681-4458-B266-CCB72D33798A Mime-Version: 1.0 (1.0) Subject: Re: Syntax for changing owner on sequence is not correct From: Tarik Dolovac X-Mailer: iPhone Mail (14G60) In-Reply-To: Date: Thu, 24 Aug 2017 20:25:13 +0200 Cc: Peter Eisentraut , "pgsql-docs@postgresql.org" Content-Transfer-Encoding: 7bit Message-Id: References: <20170809093549.8423.81493@wrigleys.postgresql.org> To: "David G. Johnston" List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org --Apple-Mail-4BF28E20-A681-4458-B266-CCB72D33798A Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable I am just telling you that in your officiall documentation i didn't find tha= t command. I founded oj stack owerflow and when i changed command I succesfu= lly 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 example= s which can make life more easily if you are starting with some new tehnolog= ies like postgres. Kind regards, Tarik Dolovac Sent from my iPhone > On 10 Aug 2017, at 16:04, David G. Johnston w= rote: >=20 >> On Thu, Aug 10, 2017 at 5:37 AM, Peter Eisentraut wrote: >=20 >> 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 ou= t >> > what is the problem >>=20 >> Are you saying that ALTER SEQUENCE ... OWNER TO doesn't work? It >> appears to work for everyone else. >=20 > =E2=80=8BSequences can have two owners - a role and, =E2=80=8Boptionally, a= table.column. >=20 > The name following "OWNED BY" is a table.column (NONE to clear). > The name following "OWNER TO" is a role (mandatory). >=20 > David J. --Apple-Mail-4BF28E20-A681-4458-B266-CCB72D33798A Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
I am just telling you that in your off= iciall 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: d= ocumentation 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 yo= u 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 <= /span><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&#39;t work al 9.5 version
> owned by
> is working please correct because I spent over 3 hour until I figure ou= t
> what is the problem

Are you saying that ALTER SEQUENCE ... OWNER TO doesn't work?  It
appears to work for everyone else.

=E2=80= =8BSequences can have two owners - a role and, =E2=80=8Boptionally, a table.= column.

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

David J.
= --Apple-Mail-4BF28E20-A681-4458-B266-CCB72D33798A--