pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedChanging the sequence owner
2+ messages / 2 participants
[nested] [flat]
* Changing the sequence owner
@ 2003-08-26 18:21 Dan Langille <dan@langille.org>
0 siblings, 1 reply; 2+ messages in thread
From: Dan Langille @ 2003-08-26 18:21 UTC (permalink / raw)
To: pgsql-docs
Should we make some reference to ALTER TABLE on the the sequence
page? A sequence owner is changed via:
alter table forums_auth_id_seq owner to phorum;
That's not intuitive unless you know the innards. We need to point
the users there.
There are references to sequences within the ALTER TABLE
documentation ("This form changes the owner of the table, index,
sequence or view to the specified user.") but you have to know about
it in the first place.
--
Dan Langille : http://www.langille.org/
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Changing the sequence owner
@ 2003-08-27 12:54 Chris M <chris@none.none>
parent: Dan Langille <dan@langille.org>
0 siblings, 0 replies; 2+ messages in thread
From: Chris M @ 2003-08-27 12:54 UTC (permalink / raw)
To: pgsql-docs
I think it is a good idea.
Providing an example is better.
""Dan Langille"" <dan@langille.org>
news:3F4B6CCC.3340.1AD4826F@localhost...
> Should we make some reference to ALTER TABLE on the the sequence
> page? A sequence owner is changed via:
>
> alter table forums_auth_id_seq owner to phorum;
>
> That's not intuitive unless you know the innards. We need to point
> the users there.
>
> There are references to sequences within the ALTER TABLE
> documentation ("This form changes the owner of the table, index,
> sequence or view to the specified user.") but you have to know about
> it in the first place.
> --
> Dan Langille : http://www.langille.org/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-08-27 12:54 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-26 18:21 Changing the sequence owner Dan Langille <dan@langille.org>
2003-08-27 12:54 ` Chris M <chris@none.none>
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