pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem about Triggers and Function
3+ messages / 3 participants
[nested] [flat]
* Problem about Triggers and Function
@ 2003-04-08 11:22 Ramesh PAtel <ramesh@banas.guj.nic.in>
0 siblings, 2 replies; 3+ messages in thread
From: Ramesh PAtel @ 2003-04-08 11:22 UTC (permalink / raw)
To: pgsql-admin@postgresql.org; +Cc: pgsql-sql; pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Problem about Triggers and Function
@ 2003-04-08 19:29 Josh Berkus <josh@agliodbs.com>
parent: Ramesh PAtel <ramesh@banas.guj.nic.in>
1 sibling, 0 replies; 3+ messages in thread
From: Josh Berkus @ 2003-04-08 19:29 UTC (permalink / raw)
To: Ramesh PAtel <ramesh@banas.guj.nic.in>; +Cc: pgsql-sql
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 Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [GENERAL] Problem about Triggers and Function
@ 2003-04-08 19:55 Dennis Gearon <gearond@cvc.net>
parent: Ramesh PAtel <ramesh@banas.guj.nic.in>
1 sibling, 0 replies; 3+ messages in thread
From: Dennis Gearon @ 2003-04-08 19:55 UTC (permalink / raw)
To: Ramesh PAtel <ramesh@banas.guj.nic.in>; +Cc: pgsql-admin@postgresql.org; pgsql-sql; pgsql-general@postgresql.org
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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-04-08 19:55 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-04-08 11:22 Problem about Triggers and Function Ramesh PAtel <ramesh@banas.guj.nic.in>
2003-04-08 19:29 ` Josh Berkus <josh@agliodbs.com>
2003-04-08 19:55 ` Dennis Gearon <gearond@cvc.net>
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