From: | Olaf Zanger <olaf(dot)zanger(at)soli-con(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, PgSQL-SQL <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: cannot create sequence |
Date: | 2001-02-15 13:01:15 |
Message-ID: | 3A8BD31B.155FAB96@soli-con.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
hi there,
good guess, they are still there.
can i just delete them?
olaf
Tom Lane schrieb:
>
> Olaf Zanger <olaf(dot)zanger(at)soli-con(dot)com> 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
--
soli-con Engineering Zanger
Dipl.-Ing. (FH) Olaf Marc Zanger
Lorrainestrasse 23
3013 Bern / Switzerland
Fon: +41-31-332 9782
Mob: +41-76-572 9782
mailto:info(at)soli-con(dot)com
mailto:olaf(dot)zanger(at)soli-con(dot)com
http://www.soli-con.com
From | Date | Subject | |
---|---|---|---|
Next Message | Olaf Zanger | 2001-02-15 13:01:56 | Re: cannot create sequence |
Previous Message | Richard Huxton | 2001-02-15 12:56:59 | Re: [GENERAL] what means "INSERT xxx yyy" ? |