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

Re: Installing dblink

From: "Ridvan Lakas ng Bayan S(dot) Baluyos" <ridvan(at)baluyos(dot)net>
To: "Andreas Wenk" <a(dot)wenk(at)netzmeister-st-pauli(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Installing dblink
Date: 2009-01-20 10:38:59
Message-ID: 7f4f9efa0901200238h7b9ae537iaaba17c421b606bb@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Thanks Andy! Everything works fine already.

+1 for you!


Ridvan

On Tue, Jan 20, 2009 at 6:31 PM, Andreas Wenk <
a(dot)wenk(at)netzmeister-st-pauli(dot)de> wrote:

> -----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-----
>



-- 
リヅバン バルヨス
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.

In response to

Responses

pgsql-novice by date

Next:From: Andreas WenkDate: 2009-01-20 10:50:16
Subject: Re: Installing dblink
Previous:From: Andreas WenkDate: 2009-01-20 10:31:34
Subject: Re: Installing dblink

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