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 2E7639DC81F
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 25 Feb 2006 06:42:59 -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 55455-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 25 Feb 2006 06:43:00 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from web25211.mail.ukl.yahoo.com (web25211.mail.ukl.yahoo.com
	[217.12.10.71]) by postgresql.org (Postfix) with SMTP id E19BF9DC819
	for <pgsql-sql@postgresql.org>; Sat, 25 Feb 2006 06:42:55 -0400 (AST)
Received: (qmail 98308 invoked by uid 60001); 25 Feb 2006 10:42:57 -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=SzBCxxvvk0ku+nHudKxpJSRV+opdyIRLNraQUrDFesbUKrhix+6YO4Oe9BD0957oNmKgQp4RgE+UpFafwOFsZ3NFWIAKQI1wZVfCHLtB3qQ2K/WKj+LWSAO0JJ56015muGndDRPaymORYLnc6QlKVI3CFzO3NS6HYeRFgkFnqUE=
	;
Message-ID: <20060225104257.98306.qmail@web25211.mail.ukl.yahoo.com>
Received: from [66.36.196.202] by web25211.mail.ukl.yahoo.com via HTTP;
	Sat, 25 Feb 2006 10:42:57 GMT
Date: Sat, 25 Feb 2006 10:42:57 +0000 (GMT)
From: Richard C <richardalancock@yahoo.co.uk>
Subject: Re: "Installing" dbLink
To: "A. Kretschmer" <andreas.kretschmer@schollglas.com>,
	pgsql-sql@postgresql.org
In-Reply-To: <20060224124346.GL20718@webserv.wug-glas.de>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1188027837-1140864177=:97458"
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/312
X-Sequence-Number: 24322

--0-1188027837-1140864177=:97458
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi. Thanks for the assistance. I have another question. Is it possible to install this function on Window XP?

"A. Kretschmer" <andreas.kretschmer@schollglas.com> wrote:  am 24.02.2006, um 11:48:44 +0000 mailte Richard C folgendes:
> 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.

You should read the docu.

Which distribution do you have? You should install the contrib-package
and then you should run the dblink.sql.

psql your_database < dblink.sql

After this, you can use dblink.



HTH, Andreas
-- 
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe === 

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org


		
---------------------------------
Yahoo! Photos – NEW, now offering a quality print service from just 8p a photo.
--0-1188027837-1140864177=:97458
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi. Thanks for the assistance. I have another question. Is it possible to install this function on Window XP?<BR><BR><B><I>"A. Kretschmer" &lt;andreas.kretschmer@schollglas.com&gt;</I></B> wrote:  <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">am 24.02.2006, um 11:48:44 +0000 mailte Richard C folgendes:<BR>&gt; Hi<BR>&gt; <BR>&gt; When I execute the query: <BR>&gt; <BR>&gt; SELECT *<BR>&gt; FROM dblink('dbname=Bas','SELECT id FROM person') AS t(a int)<BR>&gt; WHERE t.a &gt; 9000 AND T.a &lt; 9050;<BR>&gt; <BR>&gt; I receive the error message<BR>&gt; <BR>&gt; ERROR: function dblink("unknown", "unknown") does not exist<BR>&gt; <BR>&gt; How do I install or setup the function dbLink so that I can use this feature.<BR><BR>You should read the docu.<BR><BR>Which distribution do you have? You should install the contrib-package<BR>and then you should run the dblink.sql.<BR><BR>psql your_database &lt; dblink.sql<BR><BR>After this, y
 ou can
 use dblink.<BR><BR><BR><BR>HTH, Andreas<BR>-- <BR>Andreas Kretschmer (Kontakt: siehe Header)<BR>Heynitz: 035242/47215, D1: 0160/7141639<BR>GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net<BR>=== Schollglas Unternehmensgruppe === <BR><BR>---------------------------(end of broadcast)---------------------------<BR>TIP 4: Have you searched our list archives?<BR><BR>http://archives.postgresql.org<BR></BLOCKQUOTE><BR><p>
		<hr size=1><font face="Arial" size="2"><a href="http://us.rd.yahoo.com/mail/uk/taglines/default/photos/*http://uk.photos.yahoo.com/"><b>Yahoo! Photos</b></a> – <font color="red">NEW</font>, now offering a <a href="http://us.rd.yahoo.com/mail/uk/taglines/default/photos/*http://uk.photos.yahoo.com/">quality print service</a> from just 8p a photo.</font>
--0-1188027837-1140864177=:97458--