pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feed"Installing" dbLink
3+ messages / 2 participants
[nested] [flat]
* "Installing" dbLink
@ 2006-02-24 11:48 Richard C <richardalancock@yahoo.co.uk>
0 siblings, 1 reply; 3+ messages in thread
From: Richard C @ 2006-02-24 11:48 UTC (permalink / raw)
To: pgsql-sql
Hi
When I execute the query:
SELECT *
FROM dblink('dbname=Bas','SELECT id FROM person') AS t(a int)
WHERE t.a > 9000 AND T.a < 9050;
I receive the error message
ERROR: function dblink("unknown", "unknown") does not exist
How do I install or setup the function dbLink so that I can use this feature.
Regards
Richard
---------------------------------
Win a BlackBerry device from O2 with Yahoo!. Enter now.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: "Installing" dbLink
@ 2006-02-24 12:43 A. Kretschmer <andreas.kretschmer@schollglas.com>
parent: Richard C <richardalancock@yahoo.co.uk>
0 siblings, 1 reply; 3+ messages in thread
From: A. Kretschmer @ 2006-02-24 12:43 UTC (permalink / raw)
To: pgsql-sql
am 24.02.2006, um 11:48:44 +0000 mailte Richard C folgendes:
> Hi
>
> When I execute the query:
>
> SELECT *
> FROM dblink('dbname=Bas','SELECT id FROM person') AS t(a int)
> WHERE t.a > 9000 AND T.a < 9050;
>
> I receive the error message
>
> ERROR: function dblink("unknown", "unknown") does not exist
>
> How do I install or setup the function dbLink so that I can use this feature.
You should read the docu.
Which distribution do you have? You should install the contrib-package
and then you should run the dblink.sql.
psql your_database < dblink.sql
After this, you can use dblink.
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: "Installing" dbLink
@ 2006-02-25 10:42 Richard C <richardalancock@yahoo.co.uk>
parent: A. Kretschmer <andreas.kretschmer@schollglas.com>
0 siblings, 0 replies; 3+ messages in thread
From: Richard C @ 2006-02-25 10:42 UTC (permalink / raw)
To: A. Kretschmer <andreas.kretschmer@schollglas.com>; pgsql-sql
Hi. Thanks for the assistance. I have another question. Is it possible to install this function on Window XP?
"A. Kretschmer" <andreas.kretschmer@schollglas.com> wrote: am 24.02.2006, um 11:48:44 +0000 mailte Richard C folgendes:
> Hi
>
> When I execute the query:
>
> SELECT *
> FROM dblink('dbname=Bas','SELECT id FROM person') AS t(a int)
> WHERE t.a > 9000 AND T.a < 9050;
>
> I receive the error message
>
> ERROR: function dblink("unknown", "unknown") does not exist
>
> How do I install or setup the function dbLink so that I can use this feature.
You should read the docu.
Which distribution do you have? You should install the contrib-package
and then you should run the dblink.sql.
psql your_database < dblink.sql
After this, you can use dblink.
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
---------------------------------
Yahoo! Photos – NEW, now offering a quality print service from just 8p a photo.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-02-25 10:42 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-24 11:48 "Installing" dbLink Richard C <richardalancock@yahoo.co.uk>
2006-02-24 12:43 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2006-02-25 10:42 ` Richard C <richardalancock@yahoo.co.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox