Re: DBLink issue

On Fri, Nov 05, 2004 at 12:05:19PM +0200, mpanagop(at)in(dot)gr wrote:

> I would like to use dblink (postgres 7.3.5) to synchronize the data between two databases.
> I installed dblink and run the command "/usr/local/pgsql/bin/psql -U postgres template1 < dblink.sql"
> and everything seemed to work fine.

You've installed dblink in the template1 database. Databases created
from now on should get dblink, but databases that already exist won't
have it unless you install it in them as well.

> When I tried to use the command "select *from dblink(hostaddr=127.0.0.1 dbname=DB1 user=postgres', select username from users) as t1(username varchar);", I get the following message:
> ERROR: Function dblink("unknown", "unknown") does not exist
> Unable to identify a function that satisfies the given argument types
> You may need to add explicit typecasts

The SELECT statement you posted has syntax errors, so I suspect you
didn't post the exact statement you used. In any case, you appear
to be using a database that doesn't have dblink installed. If you
need dblink in databases that already exist then you'll have to
install it in each one.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/