Thread: Problem about Triggers and Function

Problem about Triggers and Function

From

"Ramesh PAtel "

Date:

08 April 2003, 18:11:29

Hi sir,

I am using PostgreSQL on Redhat Linux 7.3

Now i want to create Trigger and Function
I create one trigger but it work only for some Returns.

but i want to Trigger on table when INSER OR UPDATE any data. then
insert one row in other table related to first table data bye Trigger.

please if u have Time then u give me one TRIGGER Code. it help me

Thanking you


Ramesh Patel

ramesh@banas.guj.nic.in

Re: Problem about Triggers and Function

From

Josh Berkus

Date:

08 April 2003, 18:29:59

Ramesh,

> I am using PostgreSQL on Redhat Linux 7.3
>
> Now i want to create Trigger and Function
> I create one trigger but it work only for some Returns.

Pleas post your code to the list, so we can give you advice on how to fix it.

And please don't post a question to 4 different PostgreSQL mailing lists.
Thanks.

--
-Josh BerkusAglio Database SolutionsSan Francisco

Re: [GENERAL] Problem about Triggers and Function

From

Dennis Gearon

Date:

09 April 2003, 15:17:49

please give us code and error messages.

Ramesh PAtel wrote:
> Hi sir,
>
> I am using PostgreSQL on Redhat Linux 7.3
>
> Now i want to create Trigger and Function
> I create one trigger but it work only for some Returns.
>
> but i want to Trigger on table when INSER OR UPDATE any data. then
> insert one row in other table related to first table data bye Trigger.
>
> please if u have Time then u give me one TRIGGER Code. it help me
>
> Thanking you
>
>
> Ramesh Patel
>
> ramesh@banas.guj.nic.in
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>