> 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 > a trigger (written in C), and the table who fires the trigger is in > another database. > > I'm making the connection with SPI_connect. What can I do?? Is this > posible?? > I'd like to be able to do this too, but when I asked the question it was suggested that if you want to do this then you should use different schema's within the same database, instead of different databases. Maybe it's in the FAQ too? Given that your trigger is written in C, couldn't you use libpq to connect to and update the other database? James
