pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedtrigger proceedures in sql
8+ messages / 8 participants
[nested] [flat]
* trigger proceedures in sql
@ 2003-07-10 05:40 adivi <adivi@maximizelearning.com>
0 siblings, 5 replies; 8+ messages in thread
From: adivi @ 2003-07-10 05:40 UTC (permalink / raw)
To: pgsql-sql
hi,
can trigger proceedures ( procedures to be executed from within a trigger )
not be written in sql.
i was looking for examples and can find proceedures in 'c' only.
regards
-adivi
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: trigger proceedures in sql
@ 2003-07-10 07:56 David Witham <davidw@unidial.com.au>
0 siblings, 0 replies; 8+ messages in thread
From: David Witham @ 2003-07-10 07:56 UTC (permalink / raw)
To: adivi <adivi@maximizelearning.com>; +Cc: pgsql-sql
Hi Adivi,
You can use PL/PgSQL functions with triggers. See chapter 19 of the programmers reference:
http://www.postgresql.org/docs/7.3/static/plpgsql-trigger.html <https://bakery:10000/man/view_doc.cgi?file=/usr/share/doc/postgresql-7.3.2/html/plpgsql-trigger.html;
regards,
David
-----Original Message-----
From: adivi [mailto:adivi@maximizelearning.com]
Sent: Thursday, 10 July 2003 15:40
To: pgsql-sql@postgresql.org
Subject: [SQL] trigger proceedures in sql
hi,
can trigger proceedures ( procedures to be executed from within a trigger )
not be written in sql.
i was looking for examples and can find proceedures in 'c' only.
regards
-adivi
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: trigger proceedures in sql
@ 2003-07-10 08:29 Richard Huxton <dev@archonet.com>
parent: adivi <adivi@maximizelearning.com>
4 siblings, 0 replies; 8+ messages in thread
From: Richard Huxton @ 2003-07-10 08:29 UTC (permalink / raw)
To: adivi <adivi@maximizelearning.com>; pgsql-sql
On Thursday 10 Jul 2003 6:40 am, adivi wrote:
> hi,
>
> can trigger proceedures ( procedures to be executed from within a
> trigger ) not be written in sql.
>
> i was looking for examples and can find proceedures in 'c' only.
AFAIK you can't use "sql", but you can use "plpgsql". There is an example of a
trigger function in the docs (chapter "Procedural Languages"). Also check out
http://techdocs.postgresql.org/ - there are examples in some of the docs
there.
--
Richard Huxton
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: trigger proceedures in sql
@ 2003-07-10 14:27 Stephan Szabo <sszabo@megazone23.bigpanda.com>
parent: adivi <adivi@maximizelearning.com>
4 siblings, 0 replies; 8+ messages in thread
From: Stephan Szabo @ 2003-07-10 14:27 UTC (permalink / raw)
To: adivi <adivi@maximizelearning.com>; +Cc: pgsql-sql
On Thu, 10 Jul 2003, adivi wrote:
> can trigger proceedures ( procedures to be executed from within a trigger )
> not be written in sql.
AFAICT, no, sql functions cannot return opaque/trigger. However you can
write trigger functions in most/all of the pl languages (plpgsql, pltcl,
etc...) I think the trigger examples for plpgsql are in plpgsql's
documentation.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: trigger proceedures in sql
@ 2003-07-10 15:47 scott.marlowe <scott.marlowe@ihs.com>
parent: adivi <adivi@maximizelearning.com>
4 siblings, 0 replies; 8+ messages in thread
From: scott.marlowe @ 2003-07-10 15:47 UTC (permalink / raw)
To: adivi <adivi@maximizelearning.com>; +Cc: pgsql-sql
On Thu, 10 Jul 2003, adivi wrote:
> hi,
>
> can trigger proceedures ( procedures to be executed from within a trigger )
> not be written in sql.
>
> i was looking for examples and can find proceedures in 'c' only.
they can be written in pl/pgsql for sure, as I've written a few. :-)
Here's the section in the developer docs on triggers in plpgsql:
http://developer.postgresql.org/docs/postgres/plpgsql-trigger.html
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: trigger proceedures in sql
@ 2003-07-10 19:16 Jonathan Gardner <jgardner@jonathangardner.net>
parent: adivi <adivi@maximizelearning.com>
4 siblings, 0 replies; 8+ messages in thread
From: Jonathan Gardner @ 2003-07-10 19:16 UTC (permalink / raw)
To: adivi <adivi@maximizelearning.com>; pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Wednesday 09 July 2003 22:40, adivi wrote:
> hi,
>
> can trigger proceedures ( procedures to be executed from within a
> trigger ) not be written in sql.
>
> i was looking for examples and can find proceedures in 'c' only.
>
You may write them in PL/pgSQL, PL/Python, etc... Each language has examples
on how to set up triggers. So you will need to read about PL/pgSQL and
PL/Python to figure out how to write triggers in those languages.
I don't think you can write triggers in pure SQL.
- --
Jonathan Gardner <jgardner@jonathangardner.net>
(was jgardn@alumni.washington.edu)
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE/Dbt3WgwF3QvpWNwRAiRvAJ4ojWIGRGeuTQHY5ckOnepy0LBu9gCgoTl1
XaM7clW3uelccH/w0iaAA/k=
=R7do
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: trigger proceedures in sql
@ 2003-07-13 06:31 Rajesh Kumar Mallah <mallah@trade-india.com>
parent: adivi <adivi@maximizelearning.com>
4 siblings, 1 reply; 8+ messages in thread
From: Rajesh Kumar Mallah @ 2003-07-13 06:31 UTC (permalink / raw)
To: adivi <adivi@maximizelearning.com>; pgsql-sql
Yes of course!
contrib/dbmirror does execute a procedure written in 'C'
called recordchange() ON update , insert , delete.
If you need help in getting its source lemme know.
regds
Mallah.
On Thursday 10 Jul 2003 11:10 am, adivi wrote:
> hi,
>
> can trigger proceedures ( procedures to be executed from within a
> trigger ) not be written in sql.
>
> i was looking for examples and can find proceedures in 'c' only.
>
> regards
> -adivi
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: trigger proceedures in sql
@ 2003-07-13 12:03 Jan Wieck <JanWieck@Yahoo.com>
parent: Rajesh Kumar Mallah <mallah@trade-india.com>
0 siblings, 0 replies; 8+ messages in thread
From: Jan Wieck @ 2003-07-13 12:03 UTC (permalink / raw)
To: Rajesh Kumar Mallah <mallah@trade-india.com>; +Cc: adivi <adivi@maximizelearning.com>; pgsql-sql
Rajesh Kumar Mallah wrote:
>
> Yes of course!
> contrib/dbmirror does execute a procedure written in 'C'
> called recordchange() ON update , insert , delete.
> If you need help in getting its source lemme know.
>
> regds
> Mallah.
>
> On Thursday 10 Jul 2003 11:10 am, adivi wrote:
>> hi,
>>
>> can trigger proceedures ( procedures to be executed from within a
>> trigger ) not be written in sql.
>>
>> i was looking for examples and can find proceedures in 'c' only.
Trigger procedures can also be written in many procedural languages like
PL/Perl, PL/Tcl and PL/pgSQL (what you should be looking at closer).
Examples for PL/pgSQL can be found in the regression test.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2003-07-13 12:03 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-07-10 05:40 trigger proceedures in sql adivi <adivi@maximizelearning.com>
2003-07-10 08:29 ` Richard Huxton <dev@archonet.com>
2003-07-10 14:27 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2003-07-10 15:47 ` scott.marlowe <scott.marlowe@ihs.com>
2003-07-10 19:16 ` Jonathan Gardner <jgardner@jonathangardner.net>
2003-07-13 06:31 ` Rajesh Kumar Mallah <mallah@trade-india.com>
2003-07-13 12:03 ` Jan Wieck <JanWieck@Yahoo.com>
2003-07-10 07:56 Re: trigger proceedures in sql David Witham <davidw@unidial.com.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox