Reading source test of a function

From: "Didier Gasser-Morlay" <didiergm(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Reading source test of a function
Date: 2007-12-19 10:29:08
Message-ID: 608b66ce0712190229k2f3f752w6f5a7ef47b296b78@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

2- Where can I find a function source text in order to display it and
later resubmit it after modifications ?

I have looked in pg_catalog but it is not obvious for a postgreSQL
newbie. Please note that the functions will be written in either SQL
or pgplsql.

thanks in advance

Didier

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message A. Kretschmer 2007-12-19 10:46:24 Re: Reading source test of a function
Previous Message Adam Conrad 2007-12-16 01:36:46 Postgres Help with TPC-H