X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 6CFCE9DC821
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 24 Feb 2006 07:48:45 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 07323-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 24 Feb 2006 07:48:47 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from web25224.mail.ukl.yahoo.com (web25224.mail.ukl.yahoo.com
	[217.146.176.210])
	by postgresql.org (Postfix) with SMTP id 6B3B79DC9AD
	for <pgsql-sql@postgresql.org>; Fri, 24 Feb 2006 07:48:42 -0400 (AST)
Received: (qmail 29960 invoked by uid 60001); 24 Feb 2006 11:48:44 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk;
	h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=TYzVvM8oQ4khRLma9/lRHCz2HYaAMlUwMoZuXC2eX647A3vekH4rKc/15LW3K9olmtsDrnxv+xZYMqJeH1XsJS9zuivN0i7NTwcAz03CzYhvb3ekjfUNAVknbRFPPVLdr1QHbiJY39BqGvO+ckit5u6Yt2DohmuKfjgL2W4uoq8=
	;
Message-ID: <20060224114844.29958.qmail@web25224.mail.ukl.yahoo.com>
Received: from [66.36.196.202] by web25224.mail.ukl.yahoo.com via HTTP;
	Fri, 24 Feb 2006 11:48:44 GMT
Date: Fri, 24 Feb 2006 11:48:44 +0000 (GMT)
From: Richard C <richardalancock@yahoo.co.uk>
Subject: "Installing" dbLink
To: pgsql-sql@postgresql.org
In-Reply-To: <20060224113013.F3A6F1B816B@mx1.hub.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1931560944-1140781724=:29625"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.48 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479,
	HTML_MESSAGE=0.001]
X-Spam-Score: 0.48
X-Spam-Level: 
X-Archive-Number: 200602/293
X-Sequence-Number: 24303

--0-1931560944-1140781724=:29625
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi
   
  When I execute the query: 
   
  SELECT *
FROM dblink('dbname=Bas','SELECT id FROM person') AS t(a int)
WHERE t.a > 9000 AND T.a < 9050;
   
  I receive the error message
   
  ERROR:  function dblink("unknown", "unknown") does not exist
   
  How do I install or setup the function dbLink so that I can use this feature.
   
  Regards
  Richard

		
---------------------------------
Win a BlackBerry device from O2 with Yahoo!. Enter now.
--0-1931560944-1140781724=:29625
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV>Hi</DIV>  <DIV>&nbsp;</DIV>  <DIV>When I execute the query: </DIV>  <DIV>&nbsp;</DIV>  <DIV>SELECT *<BR>FROM dblink('dbname=Bas','SELECT id FROM person') AS t(a int)<BR>WHERE t.a &gt; 9000 AND T.a &lt; 9050;</DIV>  <DIV>&nbsp;</DIV>  <DIV>I receive the error message</DIV>  <DIV>&nbsp;</DIV>  <DIV>ERROR:&nbsp; function dblink("unknown", "unknown") does not exist</DIV>  <DIV>&nbsp;</DIV>  <DIV>How do I install or setup the function dbLink so that I can use this feature.</DIV>  <DIV>&nbsp;</DIV>  <DIV>Regards</DIV>  <DIV>Richard</DIV><p>
		<hr size=1><font face="Arial" size="2">Win a BlackBerry device from O2 with Yahoo!. <a href="http://us.rd.yahoo.com/mail/uk/taglines/default/mobile_o2/*http://www.yahoo.co.uk/blackberry"><b>Enter now</b></a>.</font>
--0-1931560944-1140781724=:29625--