From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Reading source test of a function |
Date: | 2007-12-19 10:46:24 |
Message-ID: | 20071219104624.GB27238@a-kretschmer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
am Wed, dem 19.12.2007, um 11:29:08 +0100 mailte Didier Gasser-Morlay folgendes:
> Hello,
>
> I am porting a client application from SQL-Server to PostgreSQL and so
> far .. so good. For the record, I am very pleased with the power of
> PostgreSQL.
>
> One of the features of this application is the ability to generate
> triggers on the fly, sometimes multiple triggers on the same table. so
> I have two questions:
>
> 1- Is it possible to have several trigger functions called during an
> update of one table.
Yes, of course. The triggers fires in alphabetical order, btw.
>
> 2- Where can I find a function source text in order to display it and
> later resubmit it after modifications ?
Table pg_proc, field prosrc.
But don't write directly, use 'create or replace function ...' instead.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
From | Date | Subject | |
---|---|---|---|
Next Message | Mija Lee | 2007-12-19 16:53:56 | database size question |
Previous Message | Didier Gasser-Morlay | 2007-12-19 10:29:08 | Reading source test of a function |