Received: from bast.unixathome.org (bast.unixathome.org [216.187.105.150]) by postgresql.org (Postfix) with ESMTP id 9584C475964 for ; Tue, 26 Mar 2002 15:11:40 -0500 (EST) Received: from wocker (wocker.unixathome.org [192.168.0.99]) by bast.unixathome.org (Postfix) with ESMTP id C659E3F28; Tue, 26 Mar 2002 15:11:35 -0500 (EST) From: "Dan Langille" Organization: DVL Software Limited To: Peter Atkins Date: Tue, 26 Mar 2002 15:11:33 -0500 MIME-Version: 1.0 Subject: Re: Changeing Sequence Reply-To: dan@langille.org Cc: pgsql-sql@postgresql.org In-reply-to: <02E689F991FFD311A75D009027B6A73E0886EAB1@corp_mail01.sf.nextcard.com> X-mailer: Pegasus Mail for Windows (v4.01) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body Message-Id: <20020326201135.C659E3F28@bast.unixathome.org> X-Archive-Number: 200203/347 X-Sequence-Number: 7221 On 26 Mar 2002 at 11:55, Peter Atkins wrote: > Please tell me YES! I get an error: "ERROR: You can't change sequence > relation t_staff_staff_id_seq" Yes. The above is merely a permission issue: grant update on t_staff_staff_id_seq to X... where X is you... See the docs for more details on the grant command. -- Dan Langille The FreeBSD Diary - http://freebsddiary.org/ - practical examples