pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
call an external script from pgsql 3+ messages / 2 participants [nested] [flat]
* call an external script from pgsql @ 2006-03-02 15:53 Olivier Boissard <olivier.boissard@cerene.fr> 0 siblings, 1 reply; 3+ messages in thread From: Olivier Boissard @ 2006-03-02 15:53 UTC (permalink / raw) To: pgsql-admin I would like to call an external "shell" script from a trigger. I use actually pgplsh. It works fine but there is a lot of problem with special characters. In addition I can not compile this language any more.. Do you know others solutions to call an external script? Is it possible with python ? Olivier Attachments:^ permalink raw reply [nested|flat] 3+ messages in threadolivier.boissard.vcf (text/x-vcard, 239B) download
begin:vcard fn:Olivier Boissard n:Boissard;Olivier org:Cerene Services adr:;;3 rue Archimede;La Chapelle Saint Luc;;10000;France email;internet:olivier.boissard@cerene.fr tel;work:03.25.74.11.78 tel;fax:03.25.78.39.67 version:2.1 end:vcard
* Re: call an external script from pgsql @ 2006-03-02 16:39 Peter Eisentraut <peter_e@gmx.net> parent: Olivier Boissard <olivier.boissard@cerene.fr> 0 siblings, 1 reply; 3+ messages in thread From: Peter Eisentraut @ 2006-03-02 16:39 UTC (permalink / raw) To: pgsql-admin; +Cc: Olivier Boissard <olivier.boissard@cerene.fr> Am Donnerstag, 2. März 2006 16:53 schrieb Olivier Boissard: > I would like to call an external "shell" script from a trigger. > I use actually pgplsh. It works fine but there is a lot of problem with > special characters. Details please. > In addition I can not compile this language any more.. Details please. > Do you know others solutions to call an external script? > Is it possible with python ? plperlu and plpythonu also work. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: call an external script from pgsql @ 2006-03-03 15:05 Olivier Boissard <olivier.boissard@cerene.fr> parent: Peter Eisentraut <peter_e@gmx.net> 0 siblings, 0 replies; 3+ messages in thread From: Olivier Boissard @ 2006-03-03 15:05 UTC (permalink / raw) To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin Peter Eisentraut wrote: >Am Donnerstag, 2. März 2006 16:53 schrieb Olivier Boissard: > > >>I would like to call an external "shell" script from a trigger. >>I use actually pgplsh. It works fine but there is a lot of problem with >>special characters. >> >> > >Details please. > > > >>In addition I can not compile this language any more.. >> >> > >Details please. > > > >>Do you know others solutions to call an external script? >>Is it possible with python ? >> >> > >plperlu and plpythonu also work. > > > I created a trigger on a table that contains different log information. This trigger launched a plsh function that execute a shell script to print le new record a the table (with CUPS) It worked fine but when I upgrated postgresql 7.4 -> 8.1 I was unable to recompile properly pgplsh. So I copied old libraries and sql files from a backup. It works . When I make a dump (pg_dump and psql ) the restoration fails because of specific characters used in pgplsh. And I realized that there is poor documentation on the web. That is the reason why I consider now to change this system. Olivier Attachments:^ permalink raw reply [nested|flat] 3+ messages in threadolivier.boissard.vcf (text/x-vcard, 239B) download
begin:vcard fn:Olivier Boissard n:Boissard;Olivier org:Cerene Services adr:;;3 rue Archimede;La Chapelle Saint Luc;;10000;France email;internet:olivier.boissard@cerene.fr tel;work:03.25.74.11.78 tel;fax:03.25.78.39.67 version:2.1 end:vcard
end of thread, other threads:[~2006-03-03 15:05 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2006-03-02 15:53 call an external script from pgsql Olivier Boissard <olivier.boissard@cerene.fr> 2006-03-02 16:39 ` Peter Eisentraut <peter_e@gmx.net> 2006-03-03 15:05 ` Olivier Boissard <olivier.boissard@cerene.fr>
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