Re: Installing dblink

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