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@u The Computing Froggy ----- Message d'origine ---- De : Tom Lane <tgl@xxxxxxxxxxxxx> À : Laurent ROCHE <laurent_roche@xxxxxxxxx> Cc : pgsql-general@xxxxxxxxxxxxxx Envoyé le : Vendredi, 2 Mars 2007, 19h18mn 17s Objet : Re: Re : [GENERAL] pg_dump, serial Laurent ROCHE <laurent_roche@xxxxxxxxx> 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@xxxxxxxxxxxxxx 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
