pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedSyntax for changing owner on sequence is not correct
5+ messages / 4 participants
[nested] [flat]
* Syntax for changing owner on sequence is not correct
@ 2017-08-09 09:35 tarik.dolovac.sa@gmail.com
0 siblings, 1 reply; 5+ messages in thread
From: tarik.dolovac.sa@gmail.com @ 2017-08-09 09:35 UTC (permalink / raw)
To: pgsql-docs
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
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Syntax for changing owner on sequence is not correct
@ 2017-08-10 12:37 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
parent: tarik.dolovac.sa@gmail.com
0 siblings, 1 reply; 5+ messages in thread
From: Peter Eisentraut @ 2017-08-10 12:37 UTC (permalink / raw)
To: tarik.dolovac.sa@gmail.com; pgsql-docs
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.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Syntax for changing owner on sequence is not correct
@ 2017-08-10 14:04 David G. Johnston <david.g.johnston@gmail.com>
parent: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
0 siblings, 1 reply; 5+ messages in thread
From: David G. Johnston @ 2017-08-10 14:04 UTC (permalink / raw)
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>; +Cc: pgsql-docs
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Syntax for changing owner on sequence is not correct
@ 2017-08-24 18:25 Tarik Dolovac <tarik.dolovac.sa@gmail.com>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Tarik Dolovac @ 2017-08-24 18:25 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>; pgsql-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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Syntax for changing owner on sequence is not correct
@ 2017-08-24 18:51 David G. Johnston <david.g.johnston@gmail.com>
parent: Tarik Dolovac <tarik.dolovac.sa@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: David G. Johnston @ 2017-08-24 18:51 UTC (permalink / raw)
To: Tarik Dolovac <tarik.dolovac.sa@gmail.com>; +Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>; pgsql-docs
On Thu, Aug 24, 2017 at 11:25 AM, Tarik Dolovac <tarik.dolovac.sa@gmail.com>
wrote:
> I am just telling you that in your officiall documentation i didn't find
> that command.
>
What command? Both OWNED BY and OWNER TO are parts of the ALTER SEQUENCE
command and written and described on the page you were reading when you
filled out the form.
Note that our current release is 9.5 with 10.0 in beta. Our search results
have a tendency to show old versions (you were reading 8.4) so ensuring
that you are on current stuff helps.
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.
>
Personally I tend to find well written prose and syntax specifications to
be sufficient but I don't doubt that examples are helpful. For better and
worse this is a freely available open-source product. We don't have a
mandate that every feature have 6 examples documented for its use. The
volume of questions raised about ALTER SEQUENCE is so low that the
motivation to dream up and add new examples just isn't there. If a patch
was submitted, though, it would likely be committed.
David J.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2017-08-24 18:51 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-08-09 09:35 Syntax for changing owner on sequence is not correct tarik.dolovac.sa@gmail.com
2017-08-10 12:37 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
2017-08-10 14:04 ` David G. Johnston <david.g.johnston@gmail.com>
2017-08-24 18:25 ` Tarik Dolovac <tarik.dolovac.sa@gmail.com>
2017-08-24 18:51 ` David G. Johnston <david.g.johnston@gmail.com>
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