Skip site navigation (1) Skip section navigation (2)

Trigger on Postgres for tables syncronization

From: Prabu Subroto <prabu_subroto(at)yahoo(dot)com>
To: Postgres General Milis <pgsql-general(at)postgresql(dot)org>
Subject: Trigger on Postgres for tables syncronization
Date: 2004-07-27 11:58:42
Message-ID: 20040727115842.23221.qmail@web41811.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
Dear my friends...

I am using SuSE Linux 9.1 and postgres. I am a
beginner in postgres, usually I use MySQL.

I have 3 tables : appointment, appointment0 and
appointment1.

the fields of table "appointment" are as follows:
noapp* 		(int4):ID Number of appointment (PK)
custid		(int4) : Customer ID
salesid		(int4) : Sales ID
date		(date) : Date of appointment
time		(time) : Time of appointment
todo		(char(150)) : What's to do with them
done		(char(1)): whether done (N/Y)
warned		(char(1)): whether warned with prompt
timestamp	(timestamp) : timestamp of record

"appointment0" and "appointment1" have exactly the
same field names as what "appointment" has.

But...
1. the population of "appointment0" and "appointment1"
are the subset of "appointment"
2. what the "appointment0" has are the members of
"appointment" whose "Y" as the value of fieldname
"done".
3. and what "appointmnet1" has are the members of
"appointment" whose "N" as the value of fieldname
"done". 

I want if my program inserted, updated, deleted the
record of "appointment" than the postgres does the
syncronization to the corresponded tables
(appointment0 or appointment1 or both).

Is it possible to implement this strategy with
trigger? But how?

Where Can I find a good documentation about the
trigger of postgres especially the PLPGSQL of the
postgres?

Anybody would be so nice to tell me the steps and the
command of the triggers should be in order to
implement my strategy? Please....

Please....

Thank you very much in advance.


		
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail

Responses

pgsql-general by date

Next:From: Bill MoranDate: 2004-07-27 12:38:39
Subject: PostgreSQL running in FreeBSD jail corrupts PostgreSQL running on the host system
Previous:From: John Sidney-WoollettDate: 2004-07-27 09:45:36
Subject: Re: Data model for Postfix v2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group