Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmTWU-0008HQ-Dw for pgsql-docs@arkaria.postgresql.org; Thu, 24 Jan 2019 01:09:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gmTWR-0000oO-Sa for pgsql-docs@arkaria.postgresql.org; Thu, 24 Jan 2019 01:09:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmTWQ-0000oH-LC for pgsql-docs@lists.postgresql.org; Thu, 24 Jan 2019 01:09:35 +0000 Received: from sraihb2.sra.co.jp ([202.32.10.6]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gmTWG-00042U-LK for pgsql-docs@lists.postgresql.org; Thu, 24 Jan 2019 01:09:32 +0000 Received: from srascf.sra.co.jp (srascf [133.137.8.80]) by sraihb2.sra.co.jp (Postfix) with ESMTP id 159202A428F for ; Thu, 24 Jan 2019 10:09:21 +0900 (JST) Received: from srascb.sra.co.jp (unknown [133.137.8.65]) by srascf.sra.co.jp with smtp id 19ee_0dca_37a51cae_a010_4c59_9110_1ec90d1a3b9b; Thu, 24 Jan 2019 10:09:21 +0900 Received: from sranhm.sra.co.jp (osspc25 [133.137.174.97]) by srascb.sra.co.jp (Postfix) with ESMTP id CAFC72D6942 for ; Thu, 24 Jan 2019 10:09:21 +0900 (JST) Received: from localhost (dhcp-175-172.sra.co.jp [133.137.175.172]) by sranhm.sra.co.jp (Postfix) with ESMTP id 79EEDA0DA9; Thu, 24 Jan 2019 10:09:21 +0900 (JST) Date: Thu, 24 Jan 2019 10:09:21 +0900 (JST) Message-Id: <20190124.100921.470435917664165196.t-ishii@sraoss.co.jp> To: bruce@momjian.us Cc: juergen@purtz.de, pgsql-docs@lists.postgresql.org Subject: Re: First SVG graphic From: Tatsuo Ishii In-Reply-To: <20190123235312.GB8334@momjian.us> References: <20190118.074307.1409947743977067766.t-ishii@sraoss.co.jp> <2e5ef806-c4f8-3fe7-e9a4-4fcfd124568e@purtz.de> <20190123235312.GB8334@momjian.us> X-Mailer: Mew version 6.7 on Emacs 25.2 / Mule 6.0 (HANACHIRUSATO) Mime-Version: 1.0 Content-Type: Text/Plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk > On Mon, Jan 21, 2019 at 03:02:43PM +0100, J=FCrgen Purtz wrote: >> The attached patch contains all necessary changes to the sgml, svg, = and >> Makefile. (Possibly we need some more changes regarding the 'install= *' tasks >> of Makefile.) How to go on? Shall I send the patch to a different li= st or to >> Commitfest 2019-03? > = > This is a pretty complicated issue with a lot of back-story. I am > thinking Tatsuo or me will probably commit it before March. Maybe I am missing in the discussion, but I realized that the patch does not include something like "figure number". I think it would be convenient for users to find that in the index. BTW, the patch has some trailing spaces. Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp > ---------------------------------------------------------------------= ------ > = > = >> = >> Kind regards >> = >> J=FCrgen Purtz >> = >> = >> On 17.01.19 23:43, Tatsuo Ishii wrote: >> >>>Thanks to an additional template created by Alexander Lakhin, whi= ch extends the >> >>>'nochunk' stylesheet for SVG and MathML processing, it is now pos= sible to >> >>>create the "single HTML file" of our documentation including SVG.= For me this >> >>>is a working solution as long as we use Docbook 4. After the migr= ation to >> >>>Docbook 5, both languages as well as full namespace support will = be natively >> >>>included in Docbook. >> >>> >> >>>Does anyone faced some more problems? Or can we start to include = the three >> >>>first SVG graphics into PG's documentation? >> >>OK, the wiki pages look good, as do the diagrams, and I think you = have >> >>the process we all agreed with. Should we move ahead and commit s= ome of >> >>these diagrams to the souce tree for PG 12? >> >Yes, I think we should. >> > >> >Best regards, >> >-- >> >Tatsuo Ishii >> >SRA OSS, Inc. Japan >> >English: http://www.sraoss.co.jp/index_en.php >> >Japanese:http://www.sraoss.co.jp >> > >> > > = >> diff --git a/doc/src/sgml/Makefile b/doc/src/sgml/Makefile >> index 8326c7c673..27d1e674f4 100644 >> --- a/doc/src/sgml/Makefile >> +++ b/doc/src/sgml/Makefile >> @@ -57,6 +57,8 @@ GENERATED_SGML =3D version.sgml \ >> = >> ALLSGML :=3D $(wildcard $(srcdir)/*.sgml $(srcdir)/ref/*.sgml) $(GE= NERATED_SGML) >> = >> +SVGSRC :=3D $(wildcard $(srcdir)/svg/*.svg) >> + >> = >> ## >> ## Man pages >> @@ -125,10 +127,12 @@ endif >> = >> html: html-stamp >> = >> -html-stamp: stylesheet.xsl postgres.sgml $(ALLSGML) >> +html-stamp: stylesheet.xsl postgres.sgml $(ALLSGML) $(SVGSRC) >> $(XMLLINT) $(XMLINCLUDE) --noout --valid $(word 2,$^) >> $(XSLTPROC) $(XMLINCLUDE) $(XSLTPROCFLAGS) $(XSLTPROC_HTML_FLAGS) = $(wordlist 1,2,$^) >> cp $(srcdir)/stylesheet.css html/ >> + $(MKDIR_P) html/svg >> + cp $(SVGSRC) html/svg >> touch $@ >> = >> htmlhelp: stylesheet-hh.xsl postgres.sgml $(ALLSGML) >> @@ -136,7 +140,7 @@ htmlhelp: stylesheet-hh.xsl postgres.sgml $(ALLS= GML) >> $(XSLTPROC) $(XMLINCLUDE) $(XSLTPROCFLAGS) $(wordlist 1,2,$^) >> = >> # single-page HTML >> -postgres.html: stylesheet-html-nochunk.xsl postgres.sgml $(ALLSGML)= >> +postgres.html: stylesheet-html-nochunk.xsl postgres.sgml $(ALLSGML)= $(SVGSRC) >> $(XMLLINT) $(XMLINCLUDE) --noout --valid $(word 2,$^) >> $(XSLTPROC) $(XMLINCLUDE) $(XSLTPROCFLAGS) $(XSLTPROC_HTML_FLAGS) = -o $@ $(wordlist 1,2,$^) >> = >> @@ -152,15 +156,15 @@ postgres.txt: postgres.html >> postgres.pdf: >> $(error Invalid target; use postgres-A4.pdf or postgres-US.pdf as= targets) >> = >> -%-A4.fo: stylesheet-fo.xsl %.sgml $(ALLSGML) >> +%-A4.fo: stylesheet-fo.xsl %.sgml >> $(XMLLINT) $(XMLINCLUDE) --noout --valid $(word 2,$^) >> $(XSLTPROC) $(XMLINCLUDE) $(XSLTPROCFLAGS) --stringparam paper.typ= e A4 -o $@ $(wordlist 1,2,$^) >> = >> -%-US.fo: stylesheet-fo.xsl %.sgml $(ALLSGML) >> +%-US.fo: stylesheet-fo.xsl %.sgml >> $(XMLLINT) $(XMLINCLUDE) --noout --valid $(word 2,$^) >> $(XSLTPROC) $(XMLINCLUDE) $(XSLTPROCFLAGS) --stringparam paper.typ= e USletter -o $@ $(wordlist 1,2,$^) >> = >> -%.pdf: %.fo >> +%.pdf: %.fo $(ALLSGML) $(SVGSRC) >> $(FOP) -fo $< -pdf $@ >> = >> = >> @@ -169,7 +173,7 @@ postgres.pdf: >> ## >> = >> epub: postgres.epub >> -postgres.epub: postgres.sgml $(ALLSGML) >> +postgres.epub: postgres.sgml $(ALLSGML) $(SVGSRC) >> $(XMLLINT) --noout --valid $< >> $(DBTOEPUB) $< >> = >> @@ -209,7 +213,7 @@ check: postgres.sgml $(ALLSGML) check-tabs >> install: install-html install-man >> = >> installdirs: >> - $(MKDIR_P) '$(DESTDIR)$(htmldir)'/html $(addprefix '$(DESTDIR)$(ma= ndir)'/man, 1 3 $(sqlmansectnum)) >> + $(MKDIR_P) '$(DESTDIR)$(htmldir)'/html/svg html/svg $(addprefix '$= (DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum)) >> = >> # If the install used a man directory shared with other application= s, this will remove all files. >> uninstall: >> diff --git a/doc/src/sgml/gin.sgml b/doc/src/sgml/gin.sgml >> index cc7cd1ed2c..195e385798 100644 >> --- a/doc/src/sgml/gin.sgml >> +++ b/doc/src/sgml/gin.sgml >> @@ -453,6 +453,17 @@ >> key values for different columns can be of different types. >> >> = >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> >> GIN Fast Update Technique >> = >> diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dum= p.sgml >> index 9e0bb93f08..1fd9ced5f5 100644 >> --- a/doc/src/sgml/ref/pg_dump.sgml >> +++ b/doc/src/sgml/ref/pg_dump.sgml >> @@ -73,6 +73,17 @@ PostgreSQL documentation >> architectures. >> >> = >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> >> When used with one of the archive file formats and combined with= >> pg_restore, >> diff --git a/doc/src/sgml/storage.sgml b/doc/src/sgml/storage.sgml >> index 8ef2ac8010..4d39ceb958 100644 >> --- a/doc/src/sgml/storage.sgml >> +++ b/doc/src/sgml/storage.sgml >> @@ -775,6 +775,17 @@ data. Empty in ordinary tables. >> >> >> = >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> >> = >> The first 24 bytes of each page consists of a page header >> diff --git a/doc/src/sgml/stylesheet-html-nochunk.xsl b/doc/src/sgml= /stylesheet-html-nochunk.xsl >> index ffd2012e91..9e756708f5 100644 >> --- a/doc/src/sgml/stylesheet-html-nochunk.xsl >> +++ b/doc/src/sgml/stylesheet-html-nochunk.xsl >> @@ -9,4 +9,27 @@ >> >> >> = >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> >> diff --git a/doc/src/sgml/svg/Inkscape/PageLayout_Inkscape.svg b/doc= /src/sgml/svg/Inkscape/PageLayout_Inkscape.svg >> new file mode 100644 >> index 0000000000..5803077781 >> --- /dev/null >> +++ b/doc/src/sgml/svg/Inkscape/PageLayout_Inkscape.svg >> @@ -0,0 +1,81 @@ >> + >> + >> + >> + >> + >> + image/svg+xml >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + Page La= yout >> + 8 k B >> + Fre= e space >> + >> + >> + Head= er >> + >> + Ite= mId >> + >> + Ite= mId >> + >> + >> + >> + >> + >> + >> + >> + Ite= m >> + >> + >> + Ite= m >> + >> + Spe= cial >> + >> + Cont= ent grows from start to center and from end to center. >> + >> diff --git a/doc/src/sgml/svg/Inkscape/gin_Inkscape.svg b/doc/src/sg= ml/svg/Inkscape/gin_Inkscape.svg >> new file mode 100644 >> index 0000000000..be9a9b4c73 >> --- /dev/null >> +++ b/doc/src/sgml/svg/Inkscape/gin_Inkscape.svg >> @@ -0,0 +1,124 @@ >> + >> + >> + >> + >> + >> + image/svg+xml >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + Meta = page >> + >> + >> + Entr= y tree >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + Post= ing tree >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + Pos= ting tree >> + >> + >> + >> + >> + Pos= ting tree >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + Pen= ding list >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + Poin= ters to Posting tree >> + >> + Hea= p pointers (in Posting list or Posting tree) >> + >> diff --git a/doc/src/sgml/svg/Inkscape/pgDump_Inkscape.svg b/doc/src= /sgml/svg/Inkscape/pgDump_Inkscape.svg >> new file mode 100644 >> index 0000000000..3e74b485a0 >> --- /dev/null >> +++ b/doc/src/sgml/svg/Inkscape/pgDump_Inkscape.svg >> @@ -0,0 +1,102 @@ >> + >> + >> + >> + >> + >> + image/svg+xml >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + Ori= ginal >> + Dat= abase >> + >> + pg_du= mp, script format >> + >> + pg_d= ump, other archive formats >> + >> + >> + >> + >> + SQL= INSERT >> + com= mands >> + >> + psq= l >> + >> + >> + >> + >> + Bin= ary >> + Fil= e(s) >> + >> + pg_= restore >> + >> + >> + >> + >> + Res= tored >> + Dat= abase >> + >> + >> diff --git a/doc/src/sgml/svg/PageLayout.svg b/doc/src/sgml/svg/Page= Layout.svg >> new file mode 100644 >> index 0000000000..cf504ad640 >> --- /dev/null >> +++ b/doc/src/sgml/svg/PageLayout.svg >> @@ -0,0 +1,70 @@ >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + > + fill=3D"whitesmoke" stroke=3D"#CCCCCC" /> >> + >> + >> + Page Layout >> + 8 k B >> + Free space= >> + >> + >> + Header >> + >> + ItemId >> + >> + ItemId >> + >> + >> + >> + >> + >> + >> + Item >> + >> + Item >> + >> + Special >> + >> + Content grows from= start to center and from end to center. >> + >> + >> diff --git a/doc/src/sgml/svg/gin.svg b/doc/src/sgml/svg/gin.svg >> new file mode 100644 >> index 0000000000..8a5e77b252 >> --- /dev/null >> +++ b/doc/src/sgml/svg/gin.svg >> @@ -0,0 +1,123 @@ >> + >> + >> + >> + >> + >> + >> + >> + >> + > + fill=3D"whitesmoke" stroke=3D"#CCCCCC" /> >> + >> + >> + >> + Meta page >> + >> + >> + >> + Entry tree >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + Posting tree >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + Posting tree >> + >> + >> + >> + >> + >> + Posting tree >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + Pending list >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + Pointers to Posting= tree >> + >> + Heap pointers (in = Posting list or Posting tree) >> + >> + >> diff --git a/doc/src/sgml/svg/pgDump.svg b/doc/src/sgml/svg/pgDump.s= vg >> new file mode 100644 >> index 0000000000..33e4a7d467 >> --- /dev/null >> +++ b/doc/src/sgml/svg/pgDump.svg >> @@ -0,0 +1,96 @@ >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + >> + = = >> + >> + >> + >> + >> + > + fill=3D"whitesmoke" stroke=3D"#CCCCCC" /> >> + >> + >> + >> + >> + Original >> + Database >> + >> + pg_dump, script for= mat >> + >> + pg_dump, other arc= hive formats >> + >> + >> + >> + >> + >> + SQL INSERT= >> + commands >> + >> + psql >> + >> + >> + >> + >> + >> + Binary >> + File(s) >> + >> + pg_restore= >> + >> + >> + >> + >> + >> + Restored >> + Database >> + >> + >> + >> + > = > = > -- = > Bruce Momjian http://momjian.us > EnterpriseDB http://enterprisedb.com > = > + As you are, so once was I. As I am, so you will be. + > + Ancient Roman grave inscription + > =