Re : Re : pg_dump, serial

OK, I take note of this.

I assume it's because you consider that pg_dump has only one role (to produce files to be used by pg_restore) and not two as I said in my previous email.

-------- extract from previous email --------
So to me, pg_dump has two missions:
- to create files to be used by pg_restore (format = c or t)
- to create SQL scripts (format = p) to be read by developers and to be modified by them.
-------- end of extract from previous email --------

Have fun,
L(at)u
The Computing Froggy

----- Message d'origine ----
De : Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
À : Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
Cc : pgsql-general(at)postgresql(dot)org
Envoyé le : Vendredi, 2 Mars 2007, 19h18mn 17s
Objet : Re: Re : [GENERAL] pg_dump, serial

Laurent ROCHE <laurent_roche(at)yahoo(dot)com> writes:
> I have read the given links, and I understand the reasons.

> Still, I am a bit surprised to see no mention of this in the documentation of pg_dump. I would expect to see at least a line stating that the colum declared with SERIAL will transformed to a SEQUENCE.

There is no place in the pg_dump documentation where anything is
promised about the content of the scripts it emits, except that when
executed they are supposed to regenerate the content of your database.
We have always felt free to alter the exact commands that are issued to
accomplish that. This case is not noticeably different from previous
pg_dump changes AFAICS.

In any case, the documentation of SERIAL itself makes the equivalence
clear enough:
http://www.postgresql.org/docs/8.2/static/datatype-numeric.html#DATATYPE-SERIAL

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

___________________________________________________________________________
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses
http://fr.answers.yahoo.com