Re: Installing dblink

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.