Re: cannot create sequence - Mailing list pgsql-sql

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