[HACKERS] HELP
Hello, I am creating an agent that runs alongside the postgres written in c++, I have a question: How send sql queries directly for the database without going need to make any connection? What I call function, which I use file? Thanks, -- Pedro Belmino. # Ciência da Computação - UNIFOR # [EMAIL PROTECTED]
[HACKERS] Sending queries directly
Hello, I am creating an agent that runs alongside the postgres written in c++, I have a question: How send sql queries directly for the database without going need to make any connection? What I call function, which I use file? Thanks, -- Pedro Belmino. # Ciência da Computação - UNIFOR # [EMAIL PROTECTED]
[HACKERS] Postgres.bki
Hello, I am changing the file pg_index, it is necessary to generate a new file postgres.bki? How to generate? Using the command: ./genbki.sh Thanks -- Pedro Belmino. # Ciência da Computação - UNIFOR # [EMAIL PROTECTED]
[HACKERS] Problem
Hello, I am implementing some changes in structure of index from postgresql when run the command initdb gives the following error: Bogus pg_index tuple. What it may come to be? Thanks, -- Pedro Belmino. # Ciência da Computação - UNIFOR # [EMAIL PROTECTED]
[HACKERS] Problem
Hello, I have a problem. Because some changes I made in the implementation of the creation of indexes at the time that I try to insert an index is the following error: "bogus pg_index tuple" What can be happening? Thank, -- Pedro Belmino. # Ciência da Computação - UNIFOR # [EMAIL PROTECTED]
Re: [HACKERS] Debugger
Excuse me, My previous email, I had a problem formatting of my text. So it is not understandable. Correcting: Pinged the following steps in the console: 1. Pinged the command postgres to start. 2. Joined in psql. 3. Typed the following command to get the id of the process: "SELECT pg_backend_pid();" 4. Tried to attach the id of the process to the debugger and gave the error: "Unable to open socket file: target process not responding or HotSpot VM not loaded" 2007/10/19, Pedro Belmino <[EMAIL PROTECTED]>: > > I am using linux. > 1. Inicializei the postgres the console by running. / Postgres. > 2. Joined in psql through console and simulated. / Psql > 3. Pg_backend_pid swirled SELECT () to get the id of the process; > 4. In ide tried to use that process to attach the debugger but gives the > following error message: > Unable to open file socket: target process not responding HotSpot VM or > not loaded > > Thank, > 2007/10/19, Gregory Stark <[EMAIL PROTECTED]>: > > > > > > "Pedro Belmino" <[EMAIL PROTECTED]> writes: > > > > > Hellow, > > > I continue to have problems using the debugger, can not achieve any > > > breakpoint that is outside the postmaster.c? Can anyone give me any > > hint? > > > Where do I mark a breakpoint so that I can follow the creation of an > > index > > > to file index.c for example? > > > > You have to start up your psql or other client run "SELECT > > pg_backend_pid();" > > and attach to that process in the debugger. It sounds like you've > > connected to > > the postmaster which doesn't actually do any of the work, it just forks > > other > > backends. > > > > -- > > Gregory Stark > > EnterpriseDB http://www.enterprisedb.com > > > > > > -- > Pedro Belmino. > > # Ciência da Computação - UNIFOR > # [EMAIL PROTECTED] > > -- Pedro Belmino. # Ciência da Computação - UNIFOR # [EMAIL PROTECTED]
Re: [HACKERS] Debugger
I am using linux. 1. Inicializei the postgres the console by running. / Postgres. 2. Joined in psql through console and simulated. / Psql 3. Pg_backend_pid swirled SELECT () to get the id of the process; 4. In ide tried to use that process to attach the debugger but gives the following error message: Unable to open file socket: target process not responding HotSpot VM or not loaded Thank, 2007/10/19, Gregory Stark <[EMAIL PROTECTED]>: > > > "Pedro Belmino" <[EMAIL PROTECTED]> writes: > > > Hellow, > > I continue to have problems using the debugger, can not achieve any > > breakpoint that is outside the postmaster.c? Can anyone give me any > hint? > > Where do I mark a breakpoint so that I can follow the creation of an > index > > to file index.c for example? > > You have to start up your psql or other client run "SELECT > pg_backend_pid();" > and attach to that process in the debugger. It sounds like you've > connected to > the postmaster which doesn't actually do any of the work, it just forks > other > backends. > > -- > Gregory Stark > EnterpriseDB http://www.enterprisedb.com > -- Pedro Belmino. # Ciência da Computação - UNIFOR # [EMAIL PROTECTED]
[HACKERS] Debugger
Hellow, I continue to have problems using the debugger, can not achieve any breakpoint that is outside the postmaster.c? Can anyone give me any hint? Where do I mark a breakpoint so that I can follow the creation of an index to file index.c for example? Thank, -- Pedro Belmino. # Ciência da Computação - UNIFOR # [EMAIL PROTECTED]
[HACKERS] debugger
Hellow, I continue to have problems using the debugger, can not achieve any breakpoint that is outside the postmaster.c? Can anyone give me any hint? Where do I mark a breakpoint so that I can follow the creation of an index to file index.c for example? Thank, -- Pedro Belmino. # Ciência da Computação - UNIFOR # [EMAIL PROTECTED]
[HACKERS] Index
Hello, I am implementing some functions involving index. It has some days I am with the same problem: "ERROR: bogus pg_index tuple" in the moment of the creation of an index. What this can be? Grateful, Pedro Belmino.
[HACKERS] IDE
Hello, I am having problems of productivity with IDE that I am using. Exists some IDE that recommended to develop postgresql? I am thankful, -- Pedro Belmino.
[HACKERS] Debugger
Hello, I am with a problem. When I am using debugger, breakpoints that they are inside of main function (stop the execution in the marked point) but when breakpoint is marked in another archive (index.c for example) breakpoint does not function (the execution in the point does not stop), because this happens? Thanks, Pedro Belmino.
[HACKERS] Problem
Hello, I am a developer, I am working in the creation of hypothetical index in the data base postgresql 8.2.4. I have a problem, the data base init normally but when I try to connect to the database it shows the following error: TRAP: FailedAssertion("!(!isnull)", File: "relcache.c", Line: 959) . You could help me to figure out what could it be? Yours truly.