Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1F0Eax99796 for ; Wed, 14 Feb 2001 19:14:36 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f1F0ER928728; Wed, 14 Feb 2001 19:14:28 -0500 (EST) To: olaf.zanger@soli-con.com cc: Peter Eisentraut , PgSQL-SQL Subject: Re: cannot create sequence In-reply-to: <3A8B0C2A.3642C189@soli-con.com> References: <3A8B0C2A.3642C189@soli-con.com> Comments: In-reply-to Olaf Zanger message dated "Wed, 14 Feb 2001 23:52:26 +0100" Date: Wed, 14 Feb 2001 19:14:27 -0500 Message-ID: <28725.982196067@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200102/273 X-Sequence-Number: 1464 Olaf Zanger writes: > it doesn't show ver_id_seq, nor own_id_seq when doing a \ds > but it brings up an error "cannot create sequence) if i want to > create table ver (id serial, ...); What is the *exact* text of the error message? (That ain't it.) I am guessing that a Unix file matching the desired sequence name got left around in your database directory, and that removing this file would allow you to create the sequence. However, I can't duplicate any such problem by following the procedure you describe in 7.0.2... regards, tom lane