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 992379DCC72 for ; Fri, 24 Feb 2006 11:06:22 -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 35697-06 for ; Fri, 24 Feb 2006 11:06:26 -0400 (AST) Received: from hub.org (hub.org [200.46.204.220]) by postgresql.org (Postfix) with ESMTP id 64A0F9DCC4F for ; Fri, 24 Feb 2006 11:06:20 -0400 (AST) Received: from localhost (unknown [200.46.204.144]) by hub.org (Postfix) with ESMTP id 648AD62C962 for ; Fri, 24 Feb 2006 11:06:26 -0400 (AST) Received: from hub.org ([200.46.204.220]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36434-01 for ; Fri, 24 Feb 2006 11:06:24 -0400 (AST) Received: from ganymede.hub.org (blk-222-82-85.eastlink.ca [24.222.82.85]) by hub.org (Postfix) with ESMTP id E0C7162C8AA for ; Fri, 24 Feb 2006 11:06:23 -0400 (AST) Received: by ganymede.hub.org (Postfix, from userid 1000) id 048644680D; Fri, 24 Feb 2006 11:06:29 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 0117535B05 for ; Fri, 24 Feb 2006 11:06:28 -0400 (AST) X-Return-Path: X-Received: from ganymede.hub.org ([unix socket]) by ganymede.hub.org (Cyrus v2.2.12) with LMTPA; Fri, 24 Feb 2006 07:40:25 -0400 X-Sieve: CMU Sieve 2.2 X-Received: from ganymede.hub.org (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 5FEEB4A483 for ; Fri, 24 Feb 2006 07:40:25 -0400 (AST) X-Received: from mail.postgresql.org [200.46.204.71] by ganymede.hub.org with IMAP (fetchmail-6.3.2) for (single-drop); Fri, 24 Feb 2006 07:40:25 -0400 (AST) X-Received: from postgresql.org ([unix socket]) by postgresql.org (Cyrus v2.2.12) with LMTPA; Fri, 24 Feb 2006 07:36:01 -0400 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C21409DC874 for ; Fri, 24 Feb 2006 07:36:00 -0400 (AST) X-Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 06609-01 for ; Fri, 24 Feb 2006 07:36:03 -0400 (AST) X-Received: from postgresql.org (postgresql.org [200.46.204.71]) by postgresql.org (Postfix) with ESMTP id A05499DC82F for ; Fri, 24 Feb 2006 07:35:58 -0400 (AST) X-Original-To: pgsql-sql-postgresql.org-owner@localhost.postgresql.org X-Delivered-To: pgsql-sql-postgresql.org-owner@localhost.postgresql.org X-Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 59E7B9DC821 for ; Fri, 24 Feb 2006 07:35:58 -0400 (AST) X-Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03939-07 for ; Fri, 24 Feb 2006 07:36:00 -0400 (AST) X-Greylist: delayed 00:06:40.540422 by SQLgrey- X-Received: from web25211.mail.ukl.yahoo.com (web25211.mail.ukl.yahoo.com [217.12.10.71]) by postgresql.org (Postfix) with SMTP id 8AB949DC816 for ; Fri, 24 Feb 2006 07:35:54 -0400 (AST) X-Received: (qmail 7387 invoked by uid 60001); 24 Feb 2006 11:29:16 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=OYSlGqmbWSRS7RaMKZyYLJqq23FyTCIbPyYfWUAtFUueV0C9fMbR3RVbtNU6SO33C8+CqjySElDrOS1oHVnIElq3p+QQtgcEL/V76nxc139wGDuzA9101Jp6S2vqowtarINL5SG+/1Ze/w3t/vs3bY9SjSLaqXrtXL/+mXAMaHs= ; Message-ID: <20060224112916.7385.qmail@web25211.mail.ukl.yahoo.com> X-Received: from [66.36.196.202] by web25211.mail.ukl.yahoo.com via HTTP; Fri, 24 Feb 2006 11:29:16 GMT Date: Fri, 24 Feb 2006 11:29:16 +0000 (GMT) From: Richard C Subject: dbLink Query To: pgsql-sql-owner@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-525087621-1140780556=:6353" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Virus-Scanned: by amavisd-new at hub.org ReSent-Date: Fri, 24 Feb 2006 11:06:23 -0400 (AST) ReSent-From: "Marc G. Fournier" ReSent-To: pgsql-sql@postgresql.org ReSent-Subject: dbLink Query ReSent-Message-ID: <20060224110623.O1005@ganymede.hub.org> X-Virus-Scanned: by amavisd-new at hub.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.851 required=5 tests=[AWL=1.851, HTML_MESSAGE=0.001] X-Spam-Score: 1.851 X-Spam-Level: * X-Archive-Number: 200602/332 X-Sequence-Number: 24342 --0-525087621-1140780556=:6353 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.id > 9000 AND T.ID < 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 --------------------------------- To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. --0-525087621-1140780556=:6353 Content-Type: text/html; 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.id > 9000 AND T.ID < 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

To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. --0-525087621-1140780556=:6353--