2010/10/24 tejas tank <tejas.tank....@gmail.com>: > Hello, > Thanks a lot, > This doc i have been read , i was thought it work but when i fire this > with my plsql on that time error message come that function is not define. > > how to configure the postgres database so this module will enable > is their any database driver have to setup or any configuration i have to > made. > i am use postgresql database with ubuntu operating system. yes as you > suggested solution will work but send me details how will i configure... >
Follow the instructions at: http://www.postgresql.org/docs/current/interactive/contrib.html For Ubuntu: with Synaptic Package Manager install postgresql-contrib. > My Dear, Thanks a lot for you response > > > > On Sun, Oct 24, 2010 at 3:37 AM, Osvaldo Kussama <osvaldo.kuss...@gmail.com> > wrote: >> >> 2010/10/22 Maruti Nandan <tejas.tank....@gmail.com>: >> > have any one idea !!! >> > >> > postgres db, to insert record in a table of other database through >> > function!!! >> > >> > >> > u see the dblink , but it just use for select statement i want to >> > >> > >> > when trigger fire i want to insert record in other db >> > -- >> >> >> From manual: >> >> dblink_exec executes a command (that is, any SQL statement that >> doesn't return rows) in a remote database. >> >> http://www.postgresql.org/docs/current/interactive/contrib-dblink-exec.html >> "sql: The SQL command that you wish to execute in the remote database, >> for example insert into foo values(0,'a','{"a0","b0","c0"}'). " >> Osvaldo -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
