Re: I think that my data is saved correctly, but when printing again, other data appears

2019-10-27 Thread Yessica Brinkmann
Thank you so much for the answers. By telling me this: "MemoryContextStrdup enables you to create a copy of a string in an explicitly specified memory context." I better understood the function of MemoryContextStrdup. And thank you very much to Mr. Jony Cohen for giving me the reference of his work

Re: SQL pretty pritner?

2019-10-27 Thread Adrian Klaver
On 10/27/19 3:21 PM, stan wrote: I have a presentation later in the week, and i plan on printing out some files containing SQL commands. I have used some "pretty printers" in the past for things like Perl scripts. What I am thinking of s something that bolds keywords, handles page breaks, and doe

Re: I think that my data is saved correctly, but when printing again, other data appears

2019-10-27 Thread Jony Cohen
Hi, Worked on something similar a few years back, have a look - it might give you a few pointers :) It's on similar lines to what you are looking at (I kept it updated up to PG version 9.4/9.5) https://github.com/cohenjo/pg_idx_advisor My main focus was to add support for more index types: partial

SQL pretty pritner?

2019-10-27 Thread stan
I have a presentation later in the week, and i plan on printing out some files containing SQL commands. I have used some "pretty printers" in the past for things like Perl scripts. What I am thinking of s something that bolds keywords, handles page breaks, and does some formatting. Development be

Re: I think that my data is saved correctly, but when printing again, other data appears

2019-10-27 Thread Laurenz Albe
On Fri, 2019-10-25 at 22:06 -0300, Yessica Brinkmann wrote: > What I do not understand well is how to use CurrentMemoryContext and > MemoryContextStrdup For examples using memotry contexts, search the PostgreSQL source code. To make memory management easier and safer, PostgreSQL has implemented

Re: Installation problem.

2019-10-27 Thread Laurenz Albe
Lugano Abel wrote: > Error running C:\Users\Lugano > Abel\AppData\Local\Temp/postgresql_installer_ea02e88350/temp_check_comspec.bat > : The system cannot find the path specified. This is just a guess, but maybe it doesn't like the space in the user name. Try it with a user without spaces. Yours

Installation problem.

2019-10-27 Thread Lugano Abel
Am using windows 10-64bit and installed postgresql-12.0-1-windows-x64 as i installed i disabled microsoft firewall and realtime protection and still got the following error Script stderr: Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-12 Base Dir

Re: PostgreSQL - unrecognized win32 error code: 38

2019-10-27 Thread Tom Lane
Michael Paquier writes: > On Sat, Oct 26, 2019 at 11:02:26AM -0700, Adrian Klaver wrote: >> Not sure how that can be answered without knowing what ComputeComputer is >> doing? > Yes, there is nothing of this kind in the PostgreSQL code. Sure there is: win32error.c produces exactly that message i