X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id EA846D1B8BF for ; Tue, 26 Aug 2003 15:20:43 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 89719-06 for ; Tue, 26 Aug 2003 15:20:14 -0300 (ADT) Received: from bast.unixathome.org (bast.unixathome.org [66.11.174.150]) by svr1.postgresql.org (Postfix) with ESMTP id 855D0D1B8D0 for ; Tue, 26 Aug 2003 15:20:12 -0300 (ADT) Received: from wocker (wocker.unixathome.org [192.168.0.99]) by bast.unixathome.org (Postfix) with ESMTP id 833143D29 for ; Tue, 26 Aug 2003 14:20:11 -0400 (EDT) From: "Dan Langille" To: pgsql-docs@postgresql.org Date: Tue, 26 Aug 2003 14:21:00 -0400 MIME-Version: 1.0 Subject: Changing the sequence owner Message-ID: <3F4B6CCC.3340.1AD4826F@localhost> X-mailer: Pegasus Mail for Windows (v4.02a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/77 X-Sequence-Number: 1937 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/