Обсуждение: create trigger : functions
Hi, I have written a 'C' function to be called during INSERT trigger on a table. Are there any restrictions on the functions that can be called? I know you can call SPI_* functions. But, can I call PQ* functions ? e.g PQsetdb. Is there any document which describes how the functions written for trigger are executed? Do they executed within the same process as server process or another process is started to execute the commands? regards, Sandeep
Hi, Can anyone help me . I want to know how to write triggers. i am using java and postgresql ------------------------------------------------------------------- From:- | Ms. Manika Dey. |Ph.No:-- Engineer-SC (Comp. Tech.) | IPR -- 02712 - 69276 I.P.R | EXT 336,315 BHAT, GANDHINAGAR | Residence -- 079 - 6619967 Gujrat -- 382 428 | FAX --- 69017 ------------------------------------------------------------------
On Fri, 15 Dec 2000, Manika dey wrote: > > Hi, > Can anyone help me . > I want to know how > to write triggers. > i am using java and postgresql not probably in java.... you can write function in some "internal-interpreted-language": C, Perl, Tcl, SQL, PL/SQL BTW, What is bad on PostgreSQL's docs? Karel PS. -hackers: What happen with PL/Python? Before 1/2 of year I ask if anyone works on this and answer was: "yes, but 'he' is waiting for new fmgr design". Tom's fmgr is done... IMHO it's big worse - The Python has very good design for integration to other programs.
> PS. -hackers: What happen with PL/Python? Before 1/2 of year I ask if > anyone works on this and answer was: "yes, but 'he' is waiting for new > fmgr design". Tom's fmgr is done... IMHO it's big worse - The Python > has very good design for integration to other programs. Good question. I don't remember this old message, though. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
On Tue, 19 Dec 2000, Bruce Momjian wrote: > > PS. -hackers: What happen with PL/Python? Before 1/2 of year I ask if > > anyone works on this and answer was: "yes, but 'he' is waiting for new > > fmgr design". Tom's fmgr is done... IMHO it's big worse - The Python > > has very good design for integration to other programs. > > Good question. I don't remember this old message, though. ... but I remember, in the archive is following message: > Re: Hello PL/Python > ____________________________ > > * From: Hannu Krosing <hannu@tm.ee> > * To: Karel Zak <zakkr@zf.jcu.cz> > * Subject: Re: Hello PL/Python > * Date: Thu, 20 Jul 2000 12:30:54 +0300 > _________________________________________________________________ > > Karel Zak wrote: >> >> Today afternoon I a little study libpython1.5 and I mean create >> new PL language is not a problem. >> >> I a little play with it, and here is effect: >> >> test=# CREATE FUNCTION py_test() RETURNS text AS ' >> test'# a = ''Hello ''; >> test'# b = ''PL/Python''; >> test'# plpython.retval( a + b ); >> test'# ' LANGUAGE 'plpython'; >> CREATE >> test=# >> test=# >> test=# SELECT py_test(); >> py_test >> ----------------- >> Hello PL/Python >> (1 row) >> >> Comments? Works on this already anyone? > > There is a semi-complete implementation (i.e. no trigger procedures) > by Vello Kadarpik (vello@pyystel.ee). > > He is probably waiting for fmgr redesign or somesuch to complete before > releasing it. > > --------- > Hannu Where is possible found it? IMHO it's really interesting feature. Karel --ELM980551534-4410-0_--