Обсуждение: 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_--