Hi community, while I am currently investigating why a certain table with highly redundant and utterly verbose xml becomes worse storage wise when making the xml more compact. Since i am quite new to this, I believe its the lz compression in the text database. But thats irrelevant now, just mentioning because tools like pg_filedump allow people like me to help themselves and a basic understanding of things.
During checking I noticed pg_filedump (current from git.postgresql.org incl. the below mentioned commit) does not compile on Mac-OSX. Afaik it will not compile as soon as post.h comes into play and USE_REPL_SNPRINTF is defined. Then printf and sprintf (ouch particular but code path seems tolerable) in the source of pg_filedump become pg_printf and so on. These replacements are part of postgres and can’t be linked into the standalone pg_filedump. At least that is certainly not the intention. Putting #undef sprintf #undef print after the includes in pg_filedump fixes the mac compile and imho all builds where the USE_REPL_SNPRINTF is defined as a side effect of include postgres.h effectively taking printf from me. Not sure how to deal with this issue correctly so this is just for your consideration since the issue is a bit broader imho. Regards, Stepan Am 31.08.2014 um 17:25 schrieb Fabrízio de Royes Mello <fabriziome...@gmail.com>: > > > Em domingo, 31 de agosto de 2014, Christoph Berg <c...@df7cb.de> escreveu: > Re: Fabrízio de Royes Mello 2014-06-25 > <CAFcNs+oAb8h-0w2vLEWj6R-Gv=xizgdBya3K=SCd_9Tjyo=z...@mail.gmail.com> > > On Wed, Jun 25, 2014 at 3:52 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > > > Would like that, but I'm not sure what pgindent will do with the // > > > comments. It's been on my to-do list to switch all the comments to C89 > > > style and then pgindent it, but I don't see myself getting to that in this > > > decade :-( > > > > > > > I changed all // comments to /* */ and run pgindent. > > I've pushed these patches to the git repository, thanks. > > > Thanks! > > Fabrízio de Royes Mello > > > -- > Fabrízio de Royes Mello > Consultoria/Coaching PostgreSQL > >> Timbira: http://www.timbira.com.br > >> Blog: http://fabriziomello.github.io > >> Linkedin: http://br.linkedin.com/in/fabriziomello > >> Twitter: http://twitter.com/fabriziomello > >> Github: http://github.com/fabriziomello >
smime.p7s
Description: S/MIME cryptographic signature