Thread: Changing the sequence owner

Changing the sequence owner

From

"Dan Langille"

Date:

26 August 2003, 18:27:19

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/

Re: Changing the sequence owner

From

"Chris M"

Date:

28 August 2003, 04:19:09

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
>