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

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

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

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

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