X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6C84F53683 for ; Tue, 12 Apr 2005 15:34:48 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 97023-02 for ; Tue, 12 Apr 2005 18:34:38 +0000 (GMT) Received: from boutiquenumerique.com (boutiquenumerique.com [82.67.9.10]) by svr1.postgresql.org (Postfix) with ESMTP id 9C6DD53A46 for ; Tue, 12 Apr 2005 15:34:36 -0300 (ADT) Received: (qmail 3852 invoked from network); 12 Apr 2005 20:34:38 +0200 Received: from unknown (HELO localhost) (boutiquenumerique-lists@192.168.0.4) by boutiquenumerique.com with SMTP; 12 Apr 2005 20:34:38 +0200 To: "Tom Lane" Cc: pgsql-general@postgresql.org Subject: Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin References: <5852.1112819444@sss.pgh.pa.us> <28689.1113150475@sss.pgh.pa.us> <29374.1113228303@sss.pgh.pa.us> <2396.1113236424@sss.pgh.pa.us> <2631.1113237749@sss.pgh.pa.us> Message-ID: Date: Tue, 12 Apr 2005 20:34:36 +0200 From: PFC Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?= Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <5852.1112819444@sss.pgh.pa.us> User-Agent: Opera M2(BETA2)/8.0 (Linux, build 987) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/557 X-Sequence-Number: 76470 Sometimes life has an irony of itself. Today I modified some of my gentoo USE flags for something totally unrelated to postgres. Tonight I built postgres in debug mode : the offending query worked. I thught "hm." I rebuilt it without debug, and it still works. I don't know what made it NOT to work before, I sure didn't hallucinate. It must be some obscure incompatibility deep inside the Gentoo package and build manager... phppgadmin works, and pgadmin doesn't, telling me the "datapath" column doesn't exist, no idea what this means. I'm going to look into it. Thanks for your help and sorry about bothering you ! On Mon, 11 Apr 2005 18:42:29 +0200, Tom Lane wrote: > PFC writes: >> I have no idea what to type in gbd to get the trace, though.... > > What I usually do is > - start a psql session > - in another window, find out the PID of the backend attached > to the psql session, and do > $ gdb /path/to/postgres backend_PID > ... > gdb> b errfinish > gdb> cont > - go back to psql session and issue problem command > - when gdb stops execution, do > gdb> bt > ... useful printout is here ... > gdb> quit > sure you want to exit? y > > regards, tom lane >