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 serial,
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, ...);
What is
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
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
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/
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
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