Re: [SQL] cannot create sequence

2001-02-15 Thread Tom Lane
Olaf Zanger <[EMAIL PROTECTED]> writes: > good guess, they are still there. > can i just delete them? Yes, if there's not any corresponding system-catalog entry for them. regards, tom lane

Re: [SQL] cannot create sequence

2001-02-15 Thread Olaf Zanger
um, sorry, forgot to ask then this is a bug eh :-¦ ? olaf Tom Lane schrieb: > > Olaf Zanger <[EMAIL PROTECTED]> 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, ...); >

Re: [SQL] cannot create sequence

2001-02-15 Thread Olaf Zanger
hi there, good guess, they are still there. can i just delete them? olaf Tom Lane schrieb: > > Olaf Zanger <[EMAIL PROTECTED]> 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 s

Re: [SQL] cannot create sequence

2001-02-14 Thread Tom Lane
Olaf Zanger <[EMAIL PROTECTED]> 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

Re: [SQL] cannot create sequence

2001-02-14 Thread Olaf Zanger
hi there, trouble means: 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, ...); this happend after i mistakenly did create table cng (id serial, ver_id int4 constraint ver_id_cst reference

Re: [SQL] cannot create sequence

2001-02-14 Thread Peter Eisentraut
Olaf Marc Zanger writes: > as it seems postgresql 7.0 has trouble to create > > ver_id_seq Define "trouble". -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

[SQL] cannot create sequence

2001-02-14 Thread Olaf Marc Zanger
hi there, as it seems postgresql 7.0 has trouble to create ver_id_seq and own_id_seq there is nothing visible with \dt \ds \di are these names occupied for other use? thanks for help olaf -- soli-con Engineering Zanger, Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23, 3013 Bern /