Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 973B09FB227 for ; Sat, 21 Oct 2006 00:50:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 06357-01-3 for ; Sat, 21 Oct 2006 03:49:34 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 88EA39FB3F2 for ; Sat, 21 Oct 2006 00:47:44 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k9L3le8G021070; Fri, 20 Oct 2006 23:47:40 -0400 (EDT) To: "Mohamed Yassin Eltabakh" cc: pgsql-admin@postgresql.org Subject: Re: Modifying Makefile In-reply-to: <01b801c6efb9$7221be00$e9090a80@ad.cs.purdue.edu> References: <01b801c6efb9$7221be00$e9090a80@ad.cs.purdue.edu> Comments: In-reply-to "Mohamed Yassin Eltabakh" message dated "Sat, 14 Oct 2006 13:51:58 -0400" Date: Fri, 20 Oct 2006 23:47:40 -0400 Message-ID: <21069.1161402460@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200610/135 X-Sequence-Number: 23438 "Mohamed Yassin Eltabakh" writes: > I updated the src/backend/parser/Makefile and added "new.o" to the OBJS > list, but when I compile I receive error: > ....undefined reference to `PSQLexec' > ....undefined reference to `PQntuples' > ....undefined reference to `PQclear' You seem to be trying to use the libpq client from inside the backend. This is entirely inappropriate. If you need to run general-purpose SQL queries you can use SPI, but code that is doing that probably does not belong in /parser. Just about anything that makes sense to do during parse analysis should be adequately supported by the system catalog cache routines. regards, tom lane