Re: Bug #918: pg_dump problem w/ SEQUENCE

From: Laurent FAILLIE <l_faillie(at)yahoo(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #918: pg_dump problem w/ SEQUENCE
Date: 2003-03-25 16:30:35
Message-ID: 20030325163035.27875.qmail@web13503.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi Bruce,

I duno where is the problem, because :

1/ if I do a simple CREATE SEQUENCE x; as you do, the
output is ok,

2/ It works also if I do a

CREATE SEQUENCE x
START 1
INCREMENT 1
MAXVALUE 2147483647
MINVALUE 1
CACHE 1;

which is the command used to recreate seq_id_fch when
I have upgraded to 7.3.2 (full ascii dump / rm of pg's
data directory / inidb ...).

3/ the problem is only related to this sequence, other
work.
Using the pg_dump shipped w/ 7.3.2, it works also, and
the output is like seen in point 2.

So, it's why I think it's something in the pg_dump's
code in the current snapshot. I'm investingating on my
side.

Bye

Laurent

PS: it should take some time as my workstation is
terribly ssssllloooowwww ...

=====
The misspelling master is on the Web.
_________ 100 % Dictionnary Free !
/ /(
/ Dico / / Pleins d'autres fautes sur
/________/ / http://go.to/destroyedlolo
(#######( / http://destroyedlolo.homeunix.org:8080
Quoi, des fautes d'orthographe! Pas possible ;-D.

___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dan Langille 2003-03-25 17:35:34 Re: Backend crashe with signal 11 wher restoring big database.
Previous Message KroK 2003-03-25 15:13:25 Backend crashe with signal 11 wher restoring big database.