Changing the sequence owner
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/
I think it is a good idea.
Providing an example is better.
""Dan Langille"" <dan@langille.org>
news:3F4B6CCC.3340.1AD4826F@localhost...
Show quoted text
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?