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


Thu, 14 Dec 2000 17:26:21 -0800
Sandeep Joshi <sjoshi@Zambeel.com>
create trigger : functions

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
  ------------------------------------------------------------------ 




                                       
                




Fri, 15 Dec 2000 11:36:08 -0500 (GMT)
Manika dey <bithi@ipr.res.in>
Trigger

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.


Mon, 18 Dec 2000 08:37:21 +0100 (CET)
Karel Zak <zakkr@zf.jcu.cz>
Re: [HACKERS] Trigger
> 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

Tue, 19 Dec 2000 21:48:09 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Re: [HACKERS] Trigger

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_--

Wed, 20 Dec 2000 08:56:43 +0100 (CET)
Karel Zak <zakkr@zf.jcu.cz>
PL/Python (was: Re: [GENERAL] Re: [HACKERS] Trigger)
Karel Zak wrote:
> 
> 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:
> 
> > 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.

Perhaps Vello will answer directly, but IIRC he stopped working on it
after 
a more clean implementation of the same was posted on this list.

--------------
Hannu

Wed, 20 Dec 2000 13:08:59 +0000
Hannu Krosing <hannu@tm.ee>
Re: PL/Python (was: Re: [GENERAL] Re: Trigger)

Comments anyone?

> 
> 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
> 
> 
> 


-- 
  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

Mon, 22 Jan 2001 23:47:40 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: PL/Python (was: Re: [GENERAL] Re: Trigger)

> Comments anyone?

 Yes Bruce, I already told about it with Peter in private mails. Because 
it's 1/2 of year and nobody answer I already start work on PL/Python.

 The PL/Python will in 7.2 - as soon as I can I send some proposal to 
hackers list. 

				Karel

> > 
> > 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.
> > 


Tue, 23 Jan 2001 16:48:58 +0100 (CET)
Karel Zak <zakkr@zf.jcu.cz>
Re: PL/Python (was: Re: [GENERAL] Re: Trigger)