pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
cannot create sequence
7+ messages / 4 participants
[nested] [flat]

* cannot create sequence
@ 2001-02-14 20:46 Olaf Marc Zanger <olaf.zanger@soli-con.com>
  2001-02-14 21:03 ` Re: cannot create sequence Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 7+ messages in thread

From: Olaf Marc Zanger @ 2001-02-14 20:46 UTC (permalink / raw)
  To: pgsql-sql

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 / Switzerland
fon:+41-31-332 9782, mob:+41-76-572 9782
mailto:olaf.zanger@soli-con.com, http://www.soli-con.com



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: cannot create sequence
  2001-02-14 20:46 cannot create sequence Olaf Marc Zanger <olaf.zanger@soli-con.com>
@ 2001-02-14 21:03 ` Peter Eisentraut <peter_e@gmx.net>
  2001-02-14 22:52   ` Re: cannot create sequence Olaf Zanger <olaf.zanger@soli-con.com>
  0 siblings, 1 reply; 7+ messages in thread

From: Peter Eisentraut @ 2001-02-14 21:03 UTC (permalink / raw)
  To: Olaf Marc Zanger <olaf.zanger@soli-con.com>; +Cc: pgsql-sql

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/




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: cannot create sequence
  2001-02-14 20:46 cannot create sequence Olaf Marc Zanger <olaf.zanger@soli-con.com>
  2001-02-14 21:03 ` Re: cannot create sequence Peter Eisentraut <peter_e@gmx.net>
@ 2001-02-14 22:52   ` Olaf Zanger <olaf.zanger@soli-con.com>
  2001-02-15 00:14     ` Re: cannot create sequence Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 7+ messages in thread

From: Olaf Zanger @ 2001-02-14 22:52 UTC (permalink / raw)
  To: Peter Eisentraut <peter_e@gmx.net>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: cannot create sequence
  2001-02-14 20:46 cannot create sequence Olaf Marc Zanger <olaf.zanger@soli-con.com>
  2001-02-14 21:03 ` Re: cannot create sequence Peter Eisentraut <peter_e@gmx.net>
  2001-02-14 22:52   ` Re: cannot create sequence Olaf Zanger <olaf.zanger@soli-con.com>
@ 2001-02-15 00:14     ` Tom Lane <tgl@sss.pgh.pa.us>
  2001-02-15 13:01       ` Re: cannot create sequence Olaf Zanger <olaf.zanger@soli-con.com>
  2001-02-15 13:01       ` Re: cannot create sequence Olaf Zanger <olaf.zanger@soli-con.com>
  0 siblings, 2 replies; 7+ messages in thread

From: Tom Lane @ 2001-02-15 00:14 UTC (permalink / raw)
  To: olaf.zanger@soli-con.com; +Cc: Peter Eisentraut <peter_e@gmx.net>; pgsql-sql

Olaf Zanger <olaf.zanger@soli-con.com> 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 file matching the desired sequence name got
left around in your database directory, and that removing this file
would allow you to create the sequence.  However, I can't duplicate
any such problem by following the procedure you describe in 7.0.2...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: cannot create sequence
  2001-02-14 20:46 cannot create sequence Olaf Marc Zanger <olaf.zanger@soli-con.com>
  2001-02-14 21:03 ` Re: cannot create sequence Peter Eisentraut <peter_e@gmx.net>
  2001-02-14 22:52   ` Re: cannot create sequence Olaf Zanger <olaf.zanger@soli-con.com>
  2001-02-15 00:14     ` Re: cannot create sequence Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-02-15 13:01       ` Olaf Zanger <olaf.zanger@soli-con.com>
  2001-02-15 14:54         ` Re: cannot create sequence Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 1 reply; 7+ messages in thread

From: Olaf Zanger @ 2001-02-15 13:01 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Peter Eisentraut <peter_e@gmx.net>; pgsql-sql

hi there,

good guess, they are still there.

can i just delete them?

olaf

Tom Lane schrieb:
> 
> Olaf Zanger <olaf.zanger@soli-con.com> 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 file matching the desired sequence name got
> left around in your database directory, and that removing this file
> would allow you to create the sequence.  However, I can't duplicate
> any such problem by following the procedure you describe in 7.0.2...
> 
>                         regards, tom lane

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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: cannot create sequence
  2001-02-14 20:46 cannot create sequence Olaf Marc Zanger <olaf.zanger@soli-con.com>
  2001-02-14 21:03 ` Re: cannot create sequence Peter Eisentraut <peter_e@gmx.net>
  2001-02-14 22:52   ` Re: cannot create sequence Olaf Zanger <olaf.zanger@soli-con.com>
  2001-02-15 00:14     ` Re: cannot create sequence Tom Lane <tgl@sss.pgh.pa.us>
  2001-02-15 13:01       ` Re: cannot create sequence Olaf Zanger <olaf.zanger@soli-con.com>
@ 2001-02-15 14:54         ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2001-02-15 14:54 UTC (permalink / raw)
  To: olaf.zanger@soli-con.com; +Cc: Peter Eisentraut <peter_e@gmx.net>; pgsql-sql

Olaf Zanger <olaf.zanger@soli-con.com> 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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: cannot create sequence
  2001-02-14 20:46 cannot create sequence Olaf Marc Zanger <olaf.zanger@soli-con.com>
  2001-02-14 21:03 ` Re: cannot create sequence Peter Eisentraut <peter_e@gmx.net>
  2001-02-14 22:52   ` Re: cannot create sequence Olaf Zanger <olaf.zanger@soli-con.com>
  2001-02-15 00:14     ` Re: cannot create sequence Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-02-15 13:01       ` Olaf Zanger <olaf.zanger@soli-con.com>
  1 sibling, 0 replies; 7+ messages in thread

From: Olaf Zanger @ 2001-02-15 13:01 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Peter Eisentraut <peter_e@gmx.net>; pgsql-sql

um, sorry,
forgot to ask

then this is a bug eh :-¦ ?

olaf

Tom Lane schrieb:
> 
> Olaf Zanger <olaf.zanger@soli-con.com> 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 file matching the desired sequence name got
> left around in your database directory, and that removing this file
> would allow you to create the sequence.  However, I can't duplicate
> any such problem by following the procedure you describe in 7.0.2...
> 
>                         regards, tom lane

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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2001-02-15 14:54 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-02-14 20:46 cannot create sequence Olaf Marc Zanger <olaf.zanger@soli-con.com>
2001-02-14 21:03 ` Peter Eisentraut <peter_e@gmx.net>
2001-02-14 22:52   ` Olaf Zanger <olaf.zanger@soli-con.com>
2001-02-15 00:14     ` Tom Lane <tgl@sss.pgh.pa.us>
2001-02-15 13:01       ` Olaf Zanger <olaf.zanger@soli-con.com>
2001-02-15 14:54         ` Tom Lane <tgl@sss.pgh.pa.us>
2001-02-15 13:01       ` Olaf Zanger <olaf.zanger@soli-con.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox