Trigger

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(at)candle(dot)pha(dot)pa(dot)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(at)tm(dot)ee>
> * To: Karel Zak <zakkr(at)zf(dot)jcu(dot)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(at)pyystel(dot)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_--

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(at)pyystel(dot)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

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(at)tm(dot)ee>
> > * To: Karel Zak <zakkr(at)zf(dot)jcu(dot)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(at)pyystel(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

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