Re: cannot create sequence

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 ver (id));

without having
create table ver (id serial, ...);

this happend twice. the cli and ver now are nono's for my database.

thanks for help

olaf

Peter Eisentraut schrieb:
>
> Olaf Marc Zanger writes:
>
> > as it seems postgresql 7.0 has trouble to create
> >
> > ver_id_seq
>
> Define "trouble".
>
> --
> Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/

--
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