Thread: Re : Re : pg_dump, serial

Re : Re : pg_dump, serial

From
Laurent ROCHE
Date:
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
twoas 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@sss.pgh.pa.us>
À : Laurent ROCHE <laurent_roche@yahoo.com>
Cc : pgsql-general@postgresql.org
Envoyé le : Vendredi, 2 Mars 2007, 19h18mn 17s
Objet : Re: Re : [GENERAL] pg_dump, serial

Laurent ROCHE <laurent_roche@yahoo.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
aline 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@postgresql.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

Re: Re : Re : pg_dump, serial

From
Tom Lane
Date:
Laurent ROCHE <laurent_roche@yahoo.com> writes:
> 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
twoas I said in my previous email. 

I agree that pg_dump has usefulness for creating schema documentation.
But you can't expect that the details of its output won't change across
versions.  To promise that would make it almost impossible to fix bugs,
much less add new features.

            regards, tom lane