From: itb348@gmail.com
To: pgsql-php@postgresql.org
Subject: Re: How to Create a table in another database
Date: Thu, 12 Nov 2015 21:21:47 +0100
Message-ID: <5644F4DB.9010702@googlemail.com> (raw)
In-Reply-To: <CAECtzeVAOHF2pBd8dZg+Q4FEzDYT1fdP1_ssozPB6S_LqbvLMw@mail.gmail.com>
References: <CACa6=i0J0WPTvikpeO0=VdoAiux1+MCwx4dc1=OZmO_b7GG23w@mail.gmail.com>
<CAECtzeVAOHF2pBd8dZg+Q4FEzDYT1fdP1_ssozPB6S_LqbvLMw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-php>
On 12.11.2015 19:56, Guillaume Lelarge wrote:
> Hey,
>
> 2015-11-12 11:26 GMT+01:00 Archana K N <archanakknn@gmail.com
> <mailto:archanakknn@gmail.com>>:
>
> Hello,
>
> I created a postgres function in/*db1*/, from which I need to create a
> table in another database say *db2. *I tried to use 'dblink' but it is giving
> the error:-
>
>
> ERROR: function dblink_connect(unknown, unknown) does not exist
> LINE 1: select dblink_connect('dbname=mydb port=5432 host=localhost ...
> ^
> HINT: No function matches the given name and argument types. You might need
> to add explicit type casts.
>
> Have been stuck on this for 2 days. Dont know what to do.
>
> I am using Windows 7 OS(32-bit) and due to certain security purpose am
> using Postgres 9.0(cant update it to newer version).
>
> Please help me.
>
>
> Have you installed dblink on the db1 database? If yes, can you give us the complete
> query that begins with "select dblink_connect..." ?
>
>
to me it looks like Archana is mixing PHP and SQL. "more details" certainly is the
right reaction here.
/Str.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: itb348@gmail.com
Subject: Re: How to Create a table in another database
In-Reply-To: <5644F4DB.9010702@googlemail.com>
References: <CACa6=i0J0WPTvikpeO0=VdoAiux1+MCwx4dc1=OZmO_b7GG23w@mail.gmail.com> <CAECtzeVAOHF2pBd8dZg+Q4FEzDYT1fdP1_ssozPB6S_LqbvLMw@mail.gmail.com> <5644F4DB.9010702@googlemail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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