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@gmx.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@soli-con.com
mailto:olaf.zanger@soli-con.com
http://www.soli-con.com