Re: Installing dblink - Mailing list 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@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.wenk@netzmeister-st-pauli.de <mailto:a.wenk@netzmeister-st-pauli.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.baluyos@qualservcentral.com
>         <mailto:ridvan.baluyos@qualservcentral.com>
>         <mailto:ridvan.baluyos@qualservcentral.com
>         <mailto:ridvan.baluyos@qualservcentral.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.wenk@netzmeister-st-pauli.de
>     <mailto:a.wenk@netzmeister-st-pauli.de>
>
>
>
>
> --
> リヅバン バルヨス
> ridvan.baluyos@qualservcentral.com
> <mailto:ridvan.baluyos@qualservcentral.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-----