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