Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 3D27E1337B49 for ; Mon, 28 Mar 2011 06:50:19 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 22711-09 for ; Mon, 28 Mar 2011 09:50:09 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iw0-f174.google.com (mail-iw0-f174.google.com [209.85.214.174]) by mail.postgresql.org (Postfix) with ESMTP id 7951C1337B47 for ; Mon, 28 Mar 2011 06:50:08 -0300 (ADT) Received: by iwn34 with SMTP id 34so3477265iwn.19 for ; Mon, 28 Mar 2011 02:50:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:subject:mime-version:content-type:from :in-reply-to:date:cc:content-transfer-encoding:message-id:references :to:x-mailer; bh=W3Io615lQVC0tQt1g57HgZNFKySx8tVNwRgeit33xKY=; b=ir1kmQ1Kxi42GsJlj5hHGwgjk6smzqspok0uMdCdfxMuLcrwx62VgoIQOv/xs+vMRb irF/V3sKzxRT/r1IBEPkvu1NlLSe5MdIPk/utrUfCaxfUCAGzcE0oDpIrWILVQ6wHMsG pDyk13Z2dP0eJzzG7VKPqI/DkfNxloiP7xjRA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=subject:mime-version:content-type:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to:x-mailer; b=L3olIzgkm+nImdw9RHyloT291p4CiNksiROclA/dZD7YuKKfKEDsOV61egM8r6zJ9q t0E7qQHHXzYnRqw6icfHJeoZ3xePdgDMaNKsqrVY8UJcVXRxvuJmnnIvi6Fx+5ATfHIg Y4dxPbTi8z8sCoZ44pqAoG65TzLK6GBLRZJoQ= Received: by 10.42.138.129 with SMTP id c1mr6721063icu.492.1301305808388; Mon, 28 Mar 2011 02:50:08 -0700 (PDT) Received: from [122.64.174.55] ([61.158.124.241]) by mx.google.com with ESMTPS id 13sm2846589ibo.8.2011.03.28.02.50.03 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 28 Mar 2011 02:50:07 -0700 (PDT) Subject: Re: foreign data wrappers Mime-Version: 1.0 (Apple Message framework v1082) Content-Type: text/plain; charset=iso-8859-1 From: Zheng Yang In-Reply-To: <4D903884.8070405@lelarge.info> Date: Mon, 28 Mar 2011 17:49:59 +0800 Cc: Andrew Dunstan , Shiv , Selena Deckelmann , Alvaro Herrera , pgsql-students Content-Transfer-Encoding: quoted-printable Message-Id: References: <690867AB-C50B-4354-91D0-8A0811639C4C@gmail.com> <4D879CD0.5030803@dunslane.net> <3EF9E4CC-CF42-4B45-86FF-4CB9D46D7442@gmail.com> <4D8AF8C2.3000007@lelarge.info> <4ACC318A-1B6F-49A5-9B02-49EEAF7B97C7@gmail.com> <1300985156-sup-3058@alvh.no-ip.org> <47676.208.91.122.102.1300985713.squirrel@dunslane.net> <603812A0-F464-44AE-8A90-DF9BD1DC2DB9@gmail.com> <4D8E0125.9060905@dunslane.net> <4D903884.8070405@lelarge.info> To: Guillaume Lelarge X-Mailer: Apple Mail (2.1082) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001 X-Spam-Level: X-Archive-Number: 201103/36 X-Sequence-Number: 177 Haha.. Thanks, Guilaume. Forgot to install. It works now! ZY On 28-Mar-2011, at 3:28 PM, Guillaume Lelarge wrote: > Le 27/03/2011 14:51, Zheng Yang a =E9crit : >> Hi, >>=20 >> I managed to clone a copy of 9.1devel and compiled an binary from it. = I also did a make in the 'contrib/file_fdw/' folder and a file_fdw.so = file is generated. >>=20 >> But the following error occurs when I was trying to experiment with = the file FDW: >>=20 >> postgres=3D# CREATE FUNCTION file_fdw_handler() RETURNS fdw_handler = AS 'file_fdw' LANGUAGE C STRICT; >> ERROR: could not access file "file_fdw": No such file or directory >> STATEMENT: CREATE FUNCTION file_fdw_handler() RETURNS fdw_handler AS = 'file_fdw' LANGUAGE C STRICT; >> ERROR: could not access file "file_fdw": No such file or directory >>=20 >>=20 >> Did I miss anything? >>=20 >=20 > make install? >=20 >=20 > --=20 > Guillaume > http://www.postgresql.fr > http://dalibo.com