Skip site navigation (1) Skip section navigation (2)

Re: Installing dblink

From: Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de>
To: "Ridvan Lakas ng Bayan S(dot) Baluyos" <ridvan(at)baluyos(dot)net>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Installing dblink
Date: 2009-01-20 10:31:34
Message-ID: 4975A806.3050005@netzmeister-st-pauli.de (view raw or flat)
Thread:
Lists: pgsql-novice
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Ridvan Lakas ng Bayan S. Baluyos schrieb:
> Hi Andy,
> 
> Thanks for your reply. I've already installed postgresql-contrib-8.1:
> root@<domain>:~# dpkg --list | grep "postgresql-contrib"
> ii  postgresql-contrib-8.1                          
> 8.1.8-0ubuntu6.06.1                        additional facilities for
> PostgreSQL
> 
> And still it can't recognize the dblink_connect function,
> pos=# select dblink_connect();
> ERROR:  function dblink_connect() does not exist
> HINT:  No function matches the given name and argument types. You may
> need to add explicit type casts.
> 
> 
> I've ready to dump the dblink.sql file? Where can I download it?
>

Hi Ridvan,

root(at)seven:~# find / -name dblink.sql
/usr/share/postgresql/8.1/contrib/dblink.sql

Cheers

Andy
- --
St.Pauli - Hamburg - Germany

Andreas Wenk


> Thanks,
> 
> Ridvan
> 
> On Mon, Jan 19, 2009 at 8:25 PM, Andreas Wenk
> <a(dot)wenk(at)netzmeister-st-pauli(dot)de <mailto:a(dot)wenk(at)netzmeister-st-pauli(dot)de>>
> wrote:
> 
> 
>     Ridvan Lakas ng Bayan S. Baluyos schrieb:
> 
>         Hi list,
> 
>         I'm currently having a problem. I cannot call the dblink_connect
>         function of postgres.
> 
>         pos=# select dblink_connect('dbname=postgres');
>         ERROR:  function dblink_connect("unknown") does not exist
>         HINT:  No function matches the given name and argument types.
>         You may need to add explicit type casts.
>         pos=#
> 
>         I've read this in the archives though but i still can't find the
>         contrib-package he is talking about:
>         http://archives.postgresql.org/pgsql-sql/2006-02/msg00311.php
> 
> 
>     Which OS are you running? If you are running a Debian based Linux try:
> 
>     $ apt-cache search postgresql
> 
>     You will find a package called
>     postgresql-contrib - additional facilities for PostgreSQL (latest
>     version)
> 
>     $ apt-get install postgresql-contrib
> 
>     installs the package. After that you should be able to use dblink
>     like A. Kretschmer was writing.
> 
> 
> 
>         My postgres version is 8.1.8
> 
> 
> 
>     Hint: you should upgrade to version 8.3. postgresql-contrib package
>     is always for the latest version which is 8.3 on Debian Lenny.
> 
>     Cheers
> 
>     Andy
> 
>     --
>     Andreas Wenk
> 
>     St.Pauli - Hamburg - Germany
> 
> 
> 
>         Thanks in advance!
> 
>         -- 
>         リヅバン バルヨス
>         ridvan(dot)baluyos(at)qualservcentral(dot)com
>         <mailto:ridvan(dot)baluyos(at)qualservcentral(dot)com>
>         <mailto:ridvan(dot)baluyos(at)qualservcentral(dot)com
>         <mailto:ridvan(dot)baluyos(at)qualservcentral(dot)com>>
> 
>         http://ridvan.baluyos.net
>         http://www.onxiam.com/people/rbaluyos
> 
>         Registered Linux User #439466
>         Registered Ubuntu User #16034
>         Q: Have you heard of the Object-Oriented way to get wealthy?
>         A: Inheritance.
> 
> 
>     -- 
>     ----------------------------------
>     Netzmeister St.Pauli
> 
>     St.Pauli - Hamburg - Germany
> 
>     Andreas Wenk
> 
>     Lutterothstr 82
>     20255 Hamburg
> 
>     Tel.: +49 (0) 40 319 43 54
> 
>     http://www.netzmeister-st-pauli.de
>     mailto:a(dot)wenk(at)netzmeister-st-pauli(dot)de
>     <mailto:a(dot)wenk(at)netzmeister-st-pauli(dot)de>
> 
> 
> 
> 
> -- 
> リヅバン バルヨス
> ridvan(dot)baluyos(at)qualservcentral(dot)com
> <mailto:ridvan(dot)baluyos(at)qualservcentral(dot)com>
> http://ridvan.baluyos.net
> http://www.onxiam.com/people/rbaluyos
> 
> Registered Linux User #439466
> Registered Ubuntu User #16034
> Q: Have you heard of the Object-Oriented way to get wealthy?
> A: Inheritance.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJdagGVa7znmSP9AwRAsh1AJ48QZwQHmtgtX/7Hp+P7xemXKP5bgCgnDZ0
P7+BvrUjfMwyM8M1bkqWgyo=
=2wNW
-----END PGP SIGNATURE-----

In response to

Responses

pgsql-novice by date

Next:From: Ridvan Lakas ng Bayan S. BaluyosDate: 2009-01-20 10:38:59
Subject: Re: Installing dblink
Previous:From: Suny KimDate: 2009-01-20 09:03:07
Subject: Does it make sense to set max_fsm_pages to a value over 200K?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group