Re: [GENERAL] Insert into other database

2006-02-08 Thread Rodolfo Campos
Fellows, I've restarted postgres after installing postgresql-dev package on my sarge debian box and that's it, I can connect to other database using libpq. Here is my code for anyone interested in this issue. I compiled the source code using:  gcc -fpic -shared -lpq -I/usr/include/postgresql/ser

Re: [GENERAL] Insert into other database

2006-02-08 Thread Rodolfo Campos
Thanks Michael, I'll check it out. I forgot to say to you that I'm using postgresql 7.4 that's why I can't use pl/perl. Greetings, Rodolfo. On 2/8/06, Michael Fuhr <[EMAIL PROTECTED]> wrote: [Please copy the mailing list on replies.]On Wed, Feb 08, 2006 at 06:57:11PM -0400, Rodolfo Campos wrote:

Re: [GENERAL] Insert into other database

2006-02-08 Thread Michael Fuhr
[Please copy the mailing list on replies.] On Wed, Feb 08, 2006 at 06:57:11PM -0400, Rodolfo Campos wrote: > When I tried to connect using libpq I got errors too. But this time the > error is trying to register the function in postgresql, the RDBMS tells me > that the function PQconnectdb is undef

Re: [GENERAL] Insert into other database

2006-02-08 Thread James Harper
> Hi Fellows, > > I'm wondering if in postgres we can insert a tuple into a table that is > outside of a database (I'm supossed to be connected to database1 and want > to insert a register into a table in database2). > > This question is because I want to update a tables into one database from >

Re: [GENERAL] Insert into other database

2006-02-08 Thread Michael Fuhr
On Wed, Feb 08, 2006 at 05:59:19PM -0400, Rodolfo Campos wrote: > I'm wondering if in postgres we can insert a tuple into a table that is > outside of a database (I'm supossed to be connected to database1 and want to > insert a register into a table in database2). You can do this with contrib/dbli