X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 23CEF52E2D for ; Mon, 25 Jul 2005 20:35:44 -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 26180-04 for ; Mon, 25 Jul 2005 23:35:35 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.197]) by svr1.postgresql.org (Postfix) with ESMTP id 48F1552E61 for ; Mon, 25 Jul 2005 20:35:34 -0300 (ADT) Received: by rproxy.gmail.com with SMTP id i8so524133rne for ; Mon, 25 Jul 2005 16:35:37 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=ALBLi2B5bYoojau8BcsnIiyES1i9GoB7kqsHmq4zZEslwaensA4ySnrY/gTlRX9F9QPRK6sgr4a+0N8X3GQRyWIGJjJOONOxIhyl9xPgAILVNemsbOd0wkIZRuL4rFWOvC6wWwTnJK4Vvtb/lTbTC55ZtvojBupd7zF35wBHXSg= Received: by 10.38.75.14 with SMTP id x14mr1769022rna; Mon, 25 Jul 2005 16:35:37 -0700 (PDT) Received: by 10.38.208.4 with HTTP; Mon, 25 Jul 2005 16:35:37 -0700 (PDT) Message-ID: Date: Mon, 25 Jul 2005 18:35:37 -0500 From: Mogin Mohandas Reply-To: Mogin Mohandas To: pgsql-admin@postgresql.org Subject: server side extension Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200507/198 X-Sequence-Number: 18254 Hi I was trying to built a new base data type into postgres. i am using 7.4.8 on debian. There is already an eg in src/tutorial which gives code for intenal and external functions of a new type called complex. I tried to create a shared library for the file complex.c using "cc -fpic -c complex.c" and "cc -shared -o complex.so complex.c". That gave me a lot of errors like the header files=20 "fmgr.h" and "postgres.h" did not exist. I did a "make" anyway. After that I went into postgres and tried to create the functions corresponding to the new type. It says the file complex.so could not be found. So the shared library seems to have not been created. When I installed postgres-7.4.8 there was some error when I gave "make install-all-headers", so I just did "make install". I think the header files required for server side development are not there due to that. I think they are still there in the include dir. How do I use those header files when I make a shared library and compile. If anybody has created datatypes and defined them please share your experience. Thank you Moginraj